The next step in the project is to create a final project summary for the project sponsors. Use what you learned in the Weeks Two, Three, and Four Individual assignments to create a final summary for
Introduction
This paper gives a summary on how we can resolve the discrepancies that may arise in the “U.S government student aid” database project.
The most observed discrepancy is duplication of data
We can resolve the discrepancies through the use of:
Primary keys
We will use primary keys in our table so as to identify our tables uniquely.
According to Begg C & Connolly T (2015) a primary key is the “candidate key that is selected to identify tuples uniquely within the relation”.
We will also use foreign keys when there is relationships in the tables
According to Begg C & Connolly T (2015) a foreign key is “an attribute, or set of attributes, within one relation that matches the candidate key of some (possibly the same) relation”.
Users will not be allowed to input null values through the use of SQL NOT NULL keyword
We will use data types so as to ensure that a user cannot input data that is not required in the table
We will also use the cascade on delete in tables. Cascade on delete ensures that when a record in a parent table is deleted, also the corresponding record in the child table that is enforced using relationships is deleted a well.
Begg, C & Connolly, T (2015). Database Systems. A practical approach to design, implementation, and management. Retrieved from http://people.stfx.ca/x2011/x2011asx/5th%20Year/Database/Database%20Management%20Textbook.pdf