Question: 1. (5 points) What is wrong with this table design? CUSTOMER (LastName, FirstName, Address, City, State, Zip) 2. Consider the following - (employees only work

1. (5 points) What is wrong with this table

1. (5 points) What is wrong with this table design? CUSTOMER (LastName, FirstName, Address, City, State, Zip) 2. Consider the following - (employees only work in one building and only have one email account): EMPLOYEE (Employeeld, LastName, Building, Email, DegreesEarned) Why isn't Email used as the primary key? (2 points) List any multi-valued dependencies. (2 points) Write the table(s) to be in 4NF. (6 points)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

1. (5 points) What is wrong with this table design? CUSTOMER (LastName FirstName, Address, City, State, Zip) 2. Consider the following - (employees only work in one building and only have one email...

Write an SQL statement to list ItemID and ItemDescription for all items that cost $1000 or more. Write an SQL statement to list ItemNumber and Description for all items that cost $1000 or more and...

Lab 2 Database Design Part 1 Use the database shown below to work Problems 1 through 7. Note that the database is composed of four tables and reflects these relationships: A CUSTOMER has only one...

Unit 6 Lab - SQL statements - Need help on these CIS 338: SQL/Oracle Learning Unit 6: Lab Activity Lab Activity Complete the following SQL exercises using the JustLee Books database. Launch Oracle...

Assume that The Queen Anne Curiosity Shop designs a database with the following tables. CUSTOMER (CustomerID, LastName, FirstName, Address, City, State, ZIP, Phone, Email) EMPLOYEE (EmployeeID,...

Unit 3 Assignment - SQL statements - Please be aware that I am using APEX.ORACLE.com and the SQL command statement must run successfully without errors. 1. Which orders shipped after April 1, 2009?...

SQL QUESTIONS: 1. 2. 3. 4. 5. CREATE TABLE Customers (Customer# NUMBER(4), LastName VARCHAR2(10) NOT NULL, FirstName VARCHAR2(10) NOT NULL, Address VARCHAR2(20), City VARCHAR2(12), State VARCHAR2(2),...

SQL Questions 1 through 4 - Unit 2 Lab Activity - Need help on these SQL statements, please note that I am using the cloud database version of apex.oracle. Lab Activity Complete the following SQL...

Unit 2 Lab Activity - SQL Questions 5 through 7 - Need help on these SQL statements, please note that I am using the cloud database version of apex.oracle. All other tables have no data in them. I...

The marketing research and financial departments of a company estimate that at a price of "P" dollars per unit, the weekly cost "C" and revenue "R" (in thousands of dollars) will be given by the...

Jim Emig has $ 6,000. Required: Calculate the future value of the $ 6,000 at 12 percent compounded quarterly for five years.

\ table [ [ Year , Cash Flow ] , [ 0 , - $ 9 , 4 0 0

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...