Reference no: EM133218572
Question.
Tom Luk Music is a company that provides musical instrument rental service to customers. The following database table is used to store their transaction data:
Assumptions of storing data in the table:
1. Every rental transaction is labelled by a transaction number, and may contain one or more instruments.
2. Each rental transaction is for one customer only and has one rental date.
3. Every customer has one customer ID, one name and one phone number.
4. An instrument can be rented out again immediately (in another rental transaction) even on the same day, after returned by the previous customer.
5. Every piece of instrument has an instrument number, and belongs to one of the models. However, each model may have more than one piece of instruments available (with different instruction numbers).
6. From the model name we can determine the instrument type (e.g., violin, flute)
(a) Explain why Transaction_No alone is not sufficient to form a primary key. Hence, suggest a primary key for the database table RENTAL.
(b) Write down the database RENTAL in normal form. Remember to underline the key of each table.
|
What are the effects of the procedure on a behavior
: What are the effects of the procedure on a behavior? Describe how your procedure is aligned with the attributes of your selected principle
|
|
What is the term emotional intelligence
: Could you please advise what is meant by the term "emotional intelligence" (EI).
|
|
Analyze the relationships among advertising budget
: Complete the "Price, Advertising, and Profitability" chart to include series for advertising budgets $50,000,000 and $75,000,000 on your data table
|
|
Create a program that creates and displays an array
: Create a program that creates and displays an array of customers (minimum of 10 customers) that includes their first name, last name, age, and phone number
|
|
Determine the instrument type
: Explain why Transaction_No alone is not sufficient to form a primary key. Hence, suggest a primary key for the database table RENTAL.
|
|
Write a research paper about either apiece of legislation
: Write a research paper about either apiece of legislation, executive order The legislation that you choose must be active
|
|
Evaluate the kwic index architectures
: Evaluate the KWIC Index architectures, and then select the one you believe is best for the scenario outlined above. Write up your results in a short paper
|
|
Describe the capabilities of an iis system
: What research method was used to inform recommendations? Assess the pros and cons of this approach. Describe the capabilities of an IIS system
|
|
Implement a web server that requires
: Implement a web server that requires each user to log in. You are asked to come up with two designs to store users' passwords securely
|