Q1. Within the broad "key" classification several specialized keys have been defined. List all and describe each with an example. Q4. Explain Functional dependency. Provide an example.
Q2. What are entity integrity and referential integrity? Why are they considered important?
Q3. What is a weak relationship? Give an example. What is a weak entity? Give an example
Q4. What is a relationship degree? Name and discuss the different types of relationship degree with examples.
These following questions require to you to draw out entities and their relationship using the Crow's Foot notation accurately. Write out the business rule along with the diagram. If you encounter a many to many relationship, illustrate that first, then the corrected one after that. Indicate the appropriate keys along with the attributes.
Q8. Farmer Bob, Farmer Jane and Farmer Jose run a cow farming co-op. For every cow they keep the cow's name, age (or date of birth), breed and numbered plastic ear tag. The each of the three farmers own many cows and share some of the cows with one another.
Q9. An art researcher has asked you to design a database to record details of artists and the museum in which their paintings are displayed. For each painting, the researcher wants to know the size of the canvas, year painted, title, and style. The nationality, date of birth and death of each artist must be recorded. For each museum, record details of its location and specialty, if it has one.
Q10. A hamburger shop makes several types of hamburgers, and the same ingredient can be used with several types of hamburgers. This does not literally mean the same piece of lettuce is used many times, but that lettuce is used with several types of hamburgers.