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

 

Transcribed Image Text:

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

Answer rating: 100% (QA)

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