The database is a collection of the tables and all the tables are connected with the keys. The keys are the column their respective data has uniquely differentiated the rows. The main types of keys are the primary key, foreign key, candidate key, super key, etc....
Illustrate them with simple examples for ease in understanding the concepts. 2. Given the following relations, explain what it will take to reduce them to 2NF and then to 3NF. UNDERLINE all primary keys in the resulting relation. ITALICIZE all foreign...