e day of the week, time, location, and length of class. To do this, you could create a query. What table(s) should you add to the query? If you use only the Classes table instead of all the t
Suppose you want to list information on all the classes that Pitt Fitness offers, including the day of the week, time, location, and length of class. To do this, you could create a query. What table(s) should you add to the query? If you use only the Classes table instead of all the tables together, does it make a difference to the output? What if someone had never reserved a specific class?
Answer :
Customers(customer id, last name, first name, street address, city, state, zip code, email address, phone number, birthdate, instruction id)
Take customerid as primary key.
Fully functional dependency does not require any change in the table designing. First we can split it into two tables customers, instruction.
Customers (customer id, last name, first name, street address, city, state, zip code, email address , phone number,birthdate)
Instruction (customer id, instruction id)
Coming to customers we have trasitive functional dependency (street address, city, state -> zipcode->customer id) so split into two tables. Customers and zip to be in 3nf:
3 NF:
Customers( customer id, last name, first name, email address,phone number, birthdate)
Zip(customer id, zip code, street address, city, state)
Instruction (customer id, instruction id)
Orders:
Order(order Id, order date, customer id, item id, quantity)
Take orderid as primary key.
We can split into three tables for better designing.
Those are order, order_customer, item
Order(order id, order date)
Order_customer(order id, customer id)
Item(order id, item id, quantity)
Orders:
Order(order id, order date, customer id, itemid, description, price)
Same like above we can split into three tables order, order_customer, item.
Order(order id, order date)
Order_customer(order id, customer id)
Item(order id, item id, description, price)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
