Assignment ContentThis week you will continue your work on the project to evaluate higher education student aid data. You will test your recommended U.S. Student Aid database schema, build the databas

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:

1. 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”.

1. 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”.

1. Users will not be allowed to input null values through the use of SQL NOT NULL keyword

2. We will use data types so as to ensure that a user cannot input data that is not required in the table

3. 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