When you create a database, you should follow some general guidelines for database design. What are these nine guidelines?
What will be an ideal response?
The nine guidelines are:
1. Identify the tables.
2. Determine the primary keys.
3. Determine the additional fields.
4. Determine relationships between the tables.
5. Determine data types for the fields.
6. Identify and remove any unwanted redundancy.
7. Determine a storage location for the database.
8. Determine additional properties for fields.
9. Determine the best method for distributing the database objects.
You might also like to view...
Using a computer to forecast future sales and order more inventory before a shortage can occur is an example of information system feedback.
Answer the following statement true (T) or false (F)
Which of the following buttons in Microsoft Excel 2016 can be used to combine two or more cells into one cell??
A. ?Merge & Center button B. ?Wrap Text button C. ?Orientation button D. ?Lock Cell button