Consider the data file ‘sales.csv’, which has sales data for a fictitious company with first line showing the sales attributes (fields) and each subsequent line showing a separate sales record. Each sales record has values for sales attributes (fields).

computer science

Description

– Normalization, Transaction Management and File Organization

 

 

.

 

 

1.             Consider the data file ‘sales.csv’, which has sales data for a fictitious company with first line showing the sales attributes (fields) and each subsequent line showing a separate sales record. Each sales record has values for sales attributes (fields). You are asked to store ONLY A RELEVANT PORTION of the sales data in a relational database which can have tables only in 3NF. (You are reminded that a 3NF table necessarily should also be in 2NF and 1NF.)

 

i)        Select a subset of attributes (fields) which you will store in your relational database and explain your

reasons for your selection.

(1)

ii)      Create the required database schema for the above requirements and list your database schema as a set of relation schemas (table schemas). You are reminded that a single relation schema (table schema) is written as shown below taking the DreamHome.Staff relation as an example:

 

Staff (staffNo,fName,lName,position, sex, DOB, Salary,branchNo)

 

Primary Key staffNo

 

Foreign Key branchNo references Branch(branchNo)

(4)

 

iii) Explain how each relation schema in your database is in 3NF.

(3)

 

2.             Consider the following Student table in a University Student Records database.

 

student

 

StudentId

 

fName

 

lName

discipline

432987

 

Instruction Files
sales.csv
12.7 KB
SQL.doc
126.0 KB

Related Questions in computer science category

Get Higher Grades Now
250 Tutors Online
Description

Cookies Use

We use cookies to ensure a smooth browsing experience. By continuing we assume you accept the use of cookies.

Okay