What Is Your First Step In Developing The Database

Question: What is your first step in developing the database?

Answer: Talk to the employees who will be using the database.

Question: After the interviews with users, you are ready to select the entities for the database. Which would be the most logical set of entities based on those interviews?

Answer: Supplier, Item Ordered from Supplier, and Review of Supplier

Question: Now that you have determined the entities, you can select appropriate attributes from your discussions with the users. Which attributes should your database include?

Answer: Option 2

Question: Now that you have selected the entities and attributes for your data model you are ready to decide on the identifiers for each entity. What is a good identifier for the entity “review of supplier”?

Answer: “nothing,” since users would probably not think in terms of review numbers to identify a particular review.

Question: You begin developing the tables for your database and realize that you need to design your table structures so that data integrity is protected. You recall that a process called normalization is used to improve data integrity. What is the best way to normalize this data?

Answer: Option 1, which separates supplier and contact data into two separate tables and links them by a supplier number. In this way of structuring the tables, changes to suppliers and/or to contacts can be made easily.