Reference no: EM132124470
Assignment
A restaurant is designing a database to keep track of customer services.
A customer is defined as a customer ID, name, address and a telephone number. Customers are served by employees.
Each employee is defined as an employee ID, Employee name, rank and branch. Database is designed based on the following requirements:
A customer will be served by many employees (at different times) and each employee can serve many customers at different times. All customers in the database are served by at least one employee, but not all employees in the database serve customers.
The restaurant wants to keep track of employee services, i.e. which employee served which customer at a specific time.
Based on these requirements;
a. Identify the 2 entities.
b. Identify the primary keys and attributes for each entity.
c. Draw the entity-relationship diagram
d. Normalize the entity-relationship diagram by identifying the attributes of the additional entity.
|
How does maintenix improve operational efficiency
: What information do the Maintenix modules provide to support each of these decisions?
|
|
When the software developments requirements are written
: When the software developments requirements are written in vague language it unlocks the door for interpretation .
|
|
Provide a program introduction message that tells the user
: Write a program using C#, prompt the user for the appropriate input, and display the output as described above. You may assume all data are valid.
|
|
Investing in a start up project at a cost
: You are considering investing in a start up project at a cost of $100,000. You expect the project to return $500,000 to you in seven years.
|
|
Draw the entity-relationship diagram
: A customer is defined as a customer ID, name, address and a telephone number. Customers are served by employees.
|
|
Remote powershell and exchange management shell
: You are responsible for managing multiple Exchange organizations, and you need to apply identical configurations to servers in all organizations.
|
|
What is the machine net cash flow
: If Tank is actually forecasting a salvage (for capital budgeting purposes) of $5,000 after 6 years, what is the machine's net cash flow
|
|
?market-value ratios?
: a. If? Garret's earnings per share is ?$1.65?, what is the price per share of? Garret's stock?
|
|
Draw the entity-relationship diagram
: A customer is defined as a customer ID, name, address and a telephone number. Customers are served by employees.
|