Think of the small database we used in our lab exercise - Products and Suppliers. Briefly describe how this database observes any two of the four design principles outlined above.
The small database applies a relational database. The relational database is the primary method for organizing and maintaining data today in information systems. It organizes data into tables, where each table contains lists of rows and columns similar to a spreadsheet. Each table strictly contains information about one kind of object only.
For most databases we will need more than one. For example, we might have a table that stores information about products, another table that stores information about orders, and another table with information about customers. In a relational database, we do not mix information about two different objects (e.g. orders and customers) in a single table."
You've given a good summary of the relational database model. It would also help if you make your answer specific to the small database we used in class.
回覆刪除For example, you can say that our small database has two tables - for Products and Suppliers. This shows that our data has been organized by Subject, because each table is only concerned with one subject.
The "Supplier Number" field, which is common to both tables, allows us to link or join related records from the two tables when specifying the data sources for our reports or queries.