"A good database design is, therefore, one that:
* Divides your information into subject-based tables to reduce redundant data.
* Provides the database management system (e.g. ACCESS) with the information it requires to
join the information in the tables together as needed.
* Helps support and ensure the accuracy and integrity of your information.
* Accommodates your data processing and reporting needs."
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.
"Helps support and ensure the accuracy and integrity of your information"
This system is a specific type of software for creating, storing, organizing and accessing data from a database. Business have a single, consistent source for all their data needs. A single database services multiple applications. In addition, it is able to separate the logical and physical views of data.
* Divides your information into subject-based tables to reduce redundant data.
* Provides the database management system (e.g. ACCESS) with the information it requires to
join the information in the tables together as needed.
* Helps support and ensure the accuracy and integrity of your information.
* Accommodates your data processing and reporting needs."
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.
"Helps support and ensure the accuracy and integrity of your information"
in this database system, the data is stored in tables made up of one or more collums, and it must be a single data such as character, number, text, date in each column. Also, a collection of values from each column of a table is called a record or a row from the data.
Moreover, there are relational database table which contains a key firld to uniquely identify
each record for retrieval or manipulation. For example, your name cat not be a key because there can be another person with the same name, whereas a social security number is unique.
so we can see that the system can support and ensure the accuracy and integrity of our information.
Moreover, there are relational database table which contains a key firld to uniquely identify
each record for retrieval or manipulation. For example, your name cat not be a key because there can be another person with the same name, whereas a social security number is unique.so we can see that the system can support and ensure the accuracy and integrity of our information.
"Accommodates your data processing and reporting needs"
This system is a specific type of software for creating, storing, organizing and accessing data from a database. Business have a single, consistent source for all their data needs. A single database services multiple applications. In addition, it is able to separate the logical and physical views of data. All of the function also can help us for reporting and data processing.
Good answer ! Primary keys also help support integrity of the data since no two records can be added with the same primary key value (e.g. no two customers can be assigned the same customer ID).
回覆刪除