Question: 2. Data Integrity a. Represent entities and attributes as collection of tables and attributes as given below. Eg. Customer (cust_ID, Cname....... NB: Select suitable primary

 2. Data Integrity a. Represent entities and attributes as collection of

2. Data Integrity a. Represent entities and attributes as collection of tables and attributes as given below. Eg. Customer (cust_ID, Cname....... NB: Select suitable primary key for each table and underline them. (5 Marks) b. Determine the functional dependences. (5 Marks) Eg. cust_ID --> Cname, ..., C. Normalise these tables. Make the normalization to 3NF and explain every step in the process. (10 Marks) 3. Model Building Build this model using MS Access/SQLite by creating these tables and Relationships. Populate these tables with appropriate data, at least 2 records in each table. Include following into your MS Word document. (10 Marks) 1. If you are using MS Access include following screen shots Relationship diagram created in Access. (Select database tools Relationships in the Access menu) . Data sheet view and design view of your tables as given below in Figure 1 and 2. For . Student_Name and Student_ID you need to use your MIT ID and your name as one data record. Employee EmpNum. Fname. Click to Add 101 Peter Song 102 Figure 1 Data Sheet View Figure 2 Design View II. If you are using SQLite Include screen shots of CREATE TABLE command and INSERT INTO commands. Eg. VE Figure 3 CREATE TABLE command in SQLite 1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!