Question: Normalise the following receipt to the third normal form (3NF), clearly showing the stages of ONF, 1NF, 2NF and 3NF. Clearly state any assumptions

Normalise the following receipt to the third normal form (3NF), clearly showing the stages of ONF, 1NF, 2NF 

Normalise the following receipt to the third normal form (3NF), clearly showing the stages of ONF, 1NF, 2NF and 3NF. Clearly state any assumptions you make about the data shown (e.g. derived fields), and name your final set of relations. Service Request Reference Number: 542665 Service Status: Resolved Staff Id: G2143 Staff Name: Harold Gunthorp Description: I'm having trooble with my fax machine. It ziggs and it's meant to be zagging. Joe broke it last week and nobody is coming to fix it. Actions: Actionld 523 523 151 254 ActionType Phone Support Phone Support In-person Support Item Replacement Cost 6.3 6.3 125.5 529.95 ActionService Description Called Harold, no answer Called Harold, organised a service time. Went to Harold's office to fix fax machine. It's not fixable. Purchased new fax machine to be delivered Monday Total Service Cost: 668.05 Use underlining or (PK) to depict primary keys, and italics or (FK) to depict foreign keys. Use strikethrough to show relations that have been split during the normalisation process.

Step by Step Solution

3.39 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Table in 0NFform InvoiceDetails InvoiceInvoiceDate SalesPersonID SalesPerson ItemCode ItemName Qty C... View full answer

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!