A relational database is based on one or more tables. The power of databases lie

Question

A relational database is based on one or more tables. The power of databases lies in the relationships that can be established between tables. Previously, you created a one-to-many relationship between Supplier table and Item table. The relationship was based on Supplier Code. If you had a third table, Supplier Accounts, it would use the same primary key as Supplier table, but the information would be about money transactions with that supplier. You could establish a one-to-one relationship between Supplier table and Supplier Accounts table.

This exercise explores how and why a database would use tables with a one-to-one relationship. Why divide the data into different tables? Why not simply have one large table? After all, most computers can handle large files.

Security and privacy are major factors in database creation and use. If you separate the data into three different tables, each table can have different permissions for who can access that data. For example, a university might use three tables to track student data: one table for contact information, another table for financial information, and a third table for course and grade information. This separation of tables allows for easier implementation of security by setting permissions for who can use each table. For example, a professor would not need learners' financial information and workers in the financial office would not need access to learners' grades.

Typically, tables that have a one-to-one relationship share the same primary key. Put yourself in the place of a company (or college) database administrator. Your company (or college) needs a relational database that will plan ahead for security and privacy issues. Develop three table specifications with a one-to-one relationship (that is, create a data dictionary for three tables sharing the same primary key.)

Compete the following:

Explanation / Answer

are you sure you will rate you have given a huge article as question then rate me first and then I shall post the answer you wanted

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.