File-Oriented Approach and the Database Approach - Computer Science Assignment Help

Assignment Task:

1. Compare and contrast the file-oriented approach and the database approach. Explain the main advantages of database systems.

2. Create 4 relational tables that solve the update, insert and delete anomalies in Table 4.17 below.

To avoid the update, insert and delete anomalies, four separate relational tables are created. (Note that you can add or delete rows and columns in the tables below, they are a guide only. Identify the Primary keys and foreign keys in each of your tables below).

3. Ashton wants to store the following data about S&S’s purchases of inventory:     
item number            date of purchase
vendor number            vendor address
vendor name            purchase price
quantity purchased        employee number
employee name            purchase order number
description            quantity on hand
extended amount        total amount of purchase

a. Design a set of relational tables to store this data. Do all of the data items need to be stored in a table? If not, which ones do not need to be stored and why do they not need to be stored?
b. Identify the primary key for each table.
c. Identify the foreign keys needed in the tables to implement referential integrity.

This Computer Science Assignment has been solved by our Computer Science Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.