1. What are properties of a good/bad database design? What is a functional dependency (FD)? What are the possible sources of information that defines the FDs that holds among the attributes of a relational schema? [ Hints : see from lecture slides]
2. Ruling Out FDs: Given a relation "MyTinyStore". Which FDs may exist in this relation? What do you need to rule out?

MyTinyStore

Customer_LastName	Drink_Item	Food_Item	Delivery_method
Smith	Iced_Tea	Burger	Not_Delivery
Smith	Coke	Hot Dog	Delivery
Paul	Coke	Hot Dog	Carry out
Sara	Coffee	Noodles	Carry out

1. Consider the two relations : COURSE and SECTION. Using SQL commands show that how a functional dependency can be derived from single key and multi-column keys. [ Hints: see fromhttps://dev.mysql.com/doc/refman/5.7/en/group-by-functional-dependence.html ]

Also, explain how functional dependencies can be used to indicate the following:

(i) A one-to-one relationship set exists between entity sets COURSE and SECTION.

(ii) A many-to-one relationship set exists between entity sets COURSE and SECTION.