Reference no: EM132978540
Question 1
a.Truncate table
b. Consider the following schema: CUSTOMER table with the fields as shown below
|
Column name
|
Data type
|
Required
|
Primary Key
|
|
Customer ID
|
Integer
|
Yes
|
Yes
|
|
Name
|
Char(20)
|
Yes
|
|
|
Address
|
Varchar(20)
|
Yes
|
|
|
City
|
Char(20)
|
No
|
|
|
Age
|
Integer
|
No
|
|
i. Write SQL to create table above
ii. You have skipped Phone number attribute and you need to include it. Write SQL command to do so
Create an entity relation diagram capturing information about Excellent shipping company indicating all relationships and cardinality constraints.
Question 2 Perform database normalization. Show all the steps involved in every step
Taking Emp Num as primary key;
1NF
2NF
3NF
4NF
Does the database exhibit referential and entity integrity? Explain your answer
i. Create both relations in a database called "ABC_Group"
Promote Mary Howe to manager and change her salary to $30000.00
ii. Calculate the total salary paid to all staff of ABC group
iii. Produce a list showing staff number, street, city, names, and annual salaries. Assume the salaries shown in above table are monthly salary.