Question: Redesign the database of Exercise 9 1 into first normal form
Redesign the database of Exercise 9.1 into first normal form and fourth normal form. List any functional or multivalued dependencies that you assume. Also list all referential-integrity constraints that should be present in the first- and fourth-normal-form schemas.
Answer to relevant QuestionsConsider the schemas for the table people, and the table’s students and teachers, which were created under people, in Section 9.3.Give a relational schema in third normal form that represents the same information. Recall ...Consider the relational schema shown in Figure below.a. Give a schema definition in SQL: 1999 corresponding to the relational schema, but using references to express foreign-key relationships.b. Write each of the queries in ...Give the DTD for an XML representation of the following nested-relational schema Emp = (ename, ChildrenSet setof (Children), SkillsSet setof (Skills))Children = (name, Birthday)Birthday = (day, month, year)Skills = (type, ...Consider as shown below, and suppose that authors could also appear as top level elements. What change would have to be done to the relational schema?· · · similar PCDATA declarations for year, publisher, place, journal, ...Consider the deletion of record 5 from the file as shown below compare the relative merits of the following techniques for implementing the deletion:a. Move record 6 to the space occupied by record 5, and move record 7 to ...
Post your question