Using the zip file provided, create a secure login/registration app. Make sure that your game pages (at least two) are unavailable to unregistered users. Upload a zip file with your working PHP application.
Contents of zip
Index.php
-----------------
<!DOCTYPE html>
<html>
<head>
<meta
charset="UTF-8">
<title></title>
</head>
<body>
<?php
// 1. display error
message in the session (if any): $_SESSION['error']
// 2. display either the
user's name and the game menu or the form/link below
// (display the menu by
using a php include of menu.html)
?>
<form
action="authenticate.php" method="post">
Username: <input type="text" name="user"><br>
Password: <input type="password" name="pwd"><br>
<input type="submit">
</form>
<a
href="register.php">Register a new login</a>
</body>
</html>
menu.html
---------------
<h3>Game Menu</h3>
<ul>
<li><a
href="guess.php">Guess</a></li>
</ul>
newUser.php
-------------------
<?php
session_start();
// 1. validate the input
// 2. make sure user is not already in the database
// 3. make sure that pwd and repeat match
// 4. insert a new row (be sure to hash the pwd first)
// 5. redirect to home page
header("Location: index.php");
?>
register.php
-------------
<!DOCTYPE html>
<html>
<head>
<meta
charset="UTF-8">
<title></title>
</head>
<body>
<form
action="newUser.php" method="post">
Username: <input type="text" name="user"><br>
Password: <input type="password" name="pwd"><br>
Repeat: <input type="password" name="repeat"><br>
<input type="submit">
</form>
</body>
</html>
games_ddl.sql
----------------
CREATE DATABASE games;
USE games;
CREATE TABLE users
(
id int primary key auto_increment,
username varchar(255),
password varchar(255)
);
-- insert a row into the users table for the
administrator:
-- username = foo
-- password = bar
INSERT INTO users (username, password) VALUES ('foo',
'$2y$10$IWDcVmWIHlx5nI5A.18gNOUDoJZgdfWJwFMamea9JaUK9M.iTx8g.');
Authenticate.php
---------------------
<?php
// 1. validate the form input (set $_SESSION['error'] if there
is a problem)
// 2. create a database connection (using the standard root
user)
// 3. select the password from the users table where the username
came from the form
// 4. use password_verify to see if the form password matches the
hashed password from db: password_verify($pwdFromFrom, $dbPwd)
returns a boolean
// 5. forward user to index.php
// 6. allow execution to continue and close db connection
?>
In: Computer Science
SQL Questions
1. Select ALL of the TRUE statements.
a. You can control the location of objects within a database onto specific disks/SAN LUNs only if multiple filegroups are created for each disk or SAN LUN
b. Dirty pages are data pages that have been updated in memory,
but not yet written to disk
c. DBCC CHECKDB should be executed at all times to ensure data
integrity
d. SQL Server data files and log files perform best on network shares as opposed to locally connected drives
e. Filegroups apply only to data files and not to log files
f. SQL Server always writes to the transaction log on disk
before any data page is updated in the memory buffers
g. A SQL Server data file can be a part of multiple
filegroups
2. SQL Server 2008 SP4 Enterprise Edition can be upgraded to which of the following SQL Server 2017 editions?
a. SQL Server 2017 Developer Edition
b. SQL Server 2017 Standard Edition
c. SQL Server 2017 Enterprise Edition
d. SQL Server 2017 Express Edition
3. SQL Server 2017 supports compatibility mode for which of the following versions of SQL Server?
Select one or more:
a. SQL Server 2008 R2
b. SQL Server 2005
c. SQL Server 2012
d. SQL Server 2014
e. SQL Server 2008
4. Which of the following statements are true in SQL Server?
Select ALL that apply:
a. SQL Server data files can only grow in multiples of 64K
b. You must pay for all editions of SQL Server
c. Server-side networking for SQL Server is configured at the Database level
d. It is best practice to set Auto_Update_Statistics & Auto_Create_Statistics to FALSE
e. A data page in SQL Server can only hold one object (e.g. a specific table, index, etc.)
f. SQL Server pages can be any size between 8K and 64K
g. You can have multiple versions of SQL Server installed on the same virtual server
5. Which of the following SQL Statements that will provide a list of all tables in the 'AdventureWorks2014" database and nothing else?
Group of answer choices
a. use AdventureWorks2014; Select * from sys.objects where type='TABLE'
b. use AdventureWorks2014; SELECT * FROM INFORMATION_SCHEMA.Tables WHERE TABLE_TYPE = 'BASE TABLE'
c. use AdventureWorks2014; Select * from INFORMATION_SCHEMA.TABLES
d. use AdventureWorks2014; Select * from system.tables
In: Computer Science
This database experience project has two parts: (1) creating the presentation-layer ERD, (2) developing the semantic integrity constraints (meta-data) for your data. The deliverable will include a title page with your name, your client’s name, and all sections as part of one file (.pdf).
Review the business rules described in your project files and create a presentation-layer ERD illustrating the entities/relationships needed to support your database design with accompanying data definitions. Use any graphical tool you prefer but be consistent. No gridlines – keep it clean.
Make sure to follow all rules of ER diagramming. If you see additional files (e.g., patient visit form, initial medical history form), you need to consider including the data from those forms into your database model as well. Include all entities, label relationships if there are multiple relationships between 2 entities, include all attributes and constraints where necessary and identify all primary and foreign keys as discussed.
For full credit, part 1 deliverable must include:
Semantic Integrity Constraints (or Data definitions) must be in the form of a table (use format shown below – do not add any other info columns), defining briefly each attribute of each entity, for each table. For example:
|
ENTITY |
Attribute |
Definition |
|
STUDENT |
StudentID |
12-digit number uniquely identifying the student, assigned by UH, not based on SSN or other ID |
|
STUDENT |
FirstName |
(required), character data, max-length 30 |
|
STUDENT |
MI |
Middle initial (optional), max-length 1 |
|
STUDENT |
LastName |
(required), character data, max-length 30 |
|
STUDENT |
AcctBalance |
Outstanding balance owed to the university for tuition, fees, etc. New registrants start at $0.00; 2 decimal places |
|
GRADES |
StudentID |
12-digit number uniquely identifying the student, assigned by UH, not based on SSN or other ID |
Data definitions for all attributes must be included; data-type and max length as a minimum requirement. (if the attribute is obvious such as first name, no need to define as “first name” etc.)
In: Computer Science
Periodically, Merrill Lynch customers are asked to evaluate Merrill Lynch financial consultants and services (2000 Merrill Lynch Client Satisfaction Survey). Higher ratings on the client satisfaction survey indicate better service with 7 the maximum service rating. Independent samples of service ratings for two financial consultants are summarized here. Consultant A has 10 years of experience, whereas consultant B has 1 year of experience. Use = .05 and test to see whether the consultant with more experience has the higher population mean service rating. Consultant A Consultant B = 16 = 10 = 6.82 = 6.25 = 0.7 = 0.8 State the null and alternative hypotheses. H0: 1 - 2 Ha: 1 - 2 Compute the value of the test statistic (to 2 decimals). What is the p-value? Use z-table. The p-value is What is your conclusion?
In: Statistics and Probability
|
1. a) Mr. Karim went worth have two debts, one of $2000 due in 18 months and another of 1500 due in 30 months. Enam as $3000. If the money is money 5% p.a. compounded semiannually, does he have enough money to pay his debts? If not how much additional money he needs? b) Mr. Rahim borrowed tk. 70000 from a bank and singed a promissory note bearing interest at 6% p.a compounded monthly for 6 months and on the maturity date he paid the interest in full. Also he signed a second note without interest for the next 6 months. He received Tk. 600000 with 8% interest rate. I) Determine the amount of interest paid in the 1st note. ii) What is Bank discount and find the face value of the 2nd note. |
04 05 |
In: Accounting
In 2000 Nokia wanted to enable knowledge management
and learning alternatives across its whole value chain - Suppliers
(Busines-2-Business B2B), Customers (Business-2-Customers B2C) and
Employees (Business-2-Employees B2E). This perspective would allow
Nokia to deliver understanding how to over 200 million people.
Enabling suppliers, customers, and employees easy, collaborative
and timely access to essential and valuable information about
Nokia's products and services, would increase production,
commercial awareness and improved dedication from its value string
through upgraded services, products, tools and information.
Knowledge Management System in Nokia is divided into 3 levels:
Individual level, Group level and Organizational level. Knowledge
Architecture in Nokia practices Nonaka's model. You can find four
ways to capture Knowledge: tacit to tacit communication
(socialization), tacit to explicit communication (externalization),
explicit to tacit communication (internalization), explicit to
explicit communication (combination).
One of the primary Knowledge Management enabler is Nokia Research
Centre (NRC), which is implemented for exploring new frontiers for
freedom, solving scientific issues to convert the converging
Internet and marketing communications establishments. Another
enabler, Customer Relationship Management (CRM), Nokia uses CRM to
extend the usage of vital customer information to the mobile
workforce, ensuring they have got the required resources, when and
where they want them. Also Supply Chain Management (SCM) is a KM
enabler, Nokia has integrated an operating model by using SCM to
accomplish one with their central strategies, which is to add
new-product speedily that reflect consumers' fast-changing mobile
phone tastes to ensure an industry advantage which emphasize
rapid-response processing, quick-ship logistics, and a "global
resource web" that links back to you Nokia's crops and suppliers.
There are many companies became Kilometers enablers for Nokia to
achieve their Kilometers goals. They may be Liquid Air Laboratory
GmbH, Psiloc, Kuneri Ltd. , Citrix Systems, Inc. , DiVitas Systems,
Mobien Systems Private Limited, Oracle Corp., Sam Click Ltd.,
iGuanaMobile Sdn Bhd, SYSOPENDIGIA plc, Openbit Ltd. , Secure
Digital Box AG.
In spite of the scientific possibilities and an increased volume of
computer engineers and information systems professionals, Nokia
continue steadily to face serious knowledge management problems,
due to the insufficient interdisciplinary knowledge required for an
integrated method of the complex information activities involved
with every part of work and doing business. As Nokia runs globally,
they cannot fully understand the information trends and the
implications of the global information societies and information
fads. To overcome this issue Nokia is spending abundant money on
expensive technology and tools that are not exploited to the higher
benefit of the organization. Nokia, regardless of the socioeconomic
and politics systems in which they operate, need large numbers of
information. That is especially true for those in transitional
economies. Hence Nokia is suffering from inefficient and inadequate
supervision and exploitation of these information resources.
1. What was Nokia’s strategy behind implementing a KM system? (20
points)
2. What are the main features of Nokia’s KM system? (20
points)
3. Explain the main enablers of KM system at Nokia. (30
points)
4. Explain the main challenges encountering Nokia’s KM systems. (30
points)
In: Economics
Archipelago World News, oldest newspaper in the Archipelago. Poll contacted 2000 randomly generated landline and cell phone numbers of Westopiaresidents during the past week and asked the question:
•Who are you planning on voting for?
Results: 1109 respondents support our candidate.
Conduct a significance test to determine if the poll predicts your candidate will win - that is, the majority of voters will select your candidate.
a) Write the Null and Alternative Hypotheses for this test
b) Check the assumptions necessary for this test to be valid.
c) What is the Test Statistic?
d) What is the P-value? and interpret the P-value
e) What is the 95% confidence interval for p? and interpret this interval
f) How confident are you that your candidate will win the election? and explain
- Very confident will win
- Very confident will lose
- Pretty confident will win
-Pretty confident will lose
g) Does the analysis of the poll predict your candidate will win?
h) Now it's three weeks later and the day of the election. A lot has happened since then, including a lot of negative media coverage on both candidates. Do you still think the conclusions made by you are valid? Explain
In: Statistics and Probability
2 decimals
Round to nearest whole dollar.
Nearest whole dollar.
Round to nearest whole dollar.
In: Accounting
Standard Pump recently won a $14 million contract with the U.S. Navy to supply 2000 custom-designed submersible pumps over the next four months. The contract calls for the delivery of 200 pumps at the end of May, 600 pumps at the end of June, 600 pumps at the end of July, and 600 pumps at the end of August. Standard’s production capacity is 500 pumps in May, 400 pumps in June, 800 pumps in July, and 500 pumps in August. Following relationship holds between beginning and ending inventory of each month. (Beginning Inventory) + (Current Production) - (This Month's Demand) = (Ending Inventory) Management would like to develop a production schedule that will keep monthly ending inventories low (ideally 0) while at the same time minimizing the fluctuations in production level (ideally level production strategy with same number of pumps produced each month). Assuming the production fluctuation and inventory goals are of equal importance, develop and solve an optimization model to determine the best production schedule for next 4 months. List clearly: 1) How many pumps should be produced in May, June, July and August 2) Value of optimization function. What this number tells you?
i need to know how to do this in excel.
In: Accounting
In: Accounting