ISDD+Database+Structure

media type="custom" key="28019519"


 * Questions**

1. Using the table below, give: (a) An example of a field (b) An example of a record



2. What is a flat file database?

3. Look at the table below. Describe how each of the following actions would create an anomaly. Say which anomaly. (a) Deleting the album Definitely Maybe (b) Adding the artist Calvin Harris (c) Changing the category of Nirvana to Grunge



4. How does the relational database model differ from a flat file database?

5. Using the albums database in question above, how might the database be changed in order to make it relational.

6. What is needed in order to link tables in a database?

7. What is meant by atomic data?

Practical Exercises