a) Draw a structured design for the \'Create call list functional 4 marks primit

Question

a) Draw a structured design for the 'Create call list functional 4 marks primitive. b) Draw a decision tree for the 'Create appt list functional 4 marks primitive. The following table is in first normal form. Convert it to second normal form, remembering that you will have more than one table in your answer. When your answer is complete, underline the primary keys, remembering that a primary key can consist of more than one attribute. 8. 5 marks DNumber DMgrTFN DLocation DName Research Research Research Administration Senior Management 1 333444555 Mawson Lakes 333444555 City West 333444555 Magill 987987987 City West 123123123 City East 5 5 4

Explanation / Answer

We can have two tables:

Table 1

Did Dnumber Dlocaton   (We will have one more id field as the primary key)

Table 2

Did DMgrTFN

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.