Reference no: EM132124466
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.
|
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.
|
|
Possible downsides of momentum investing
: What are the possible downsides of momentum investing? Is it worth it do utilise this approach?
|
|
Identified two annuities that are available for purchase
: A client has identified two annuities that are available for purchase, The first annuity pays $1,000 at the end of each month over a 3-year period
|
|
What is the annual percentage rate
: Assuming there are 360 days in a year and Grant currently holds no funds at the lending bank, what is the annual percentage rate (APR) of the loan?
|
|
What is ram receivables collection period
: What is RAM's receivables collection period (DSO)? In your computations, assume there are 360 days in a year.
|