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