Long Questions
Given the sample records in the CHARTER table shown in Table P6.11, do the following: The manager of a consulting firm has asked you to evaluate a database that contains the table structure shown in Table P6.10. Suppose that you have been given the table structure and data shown in Table 6.9, which was imported from an Excel spreadsheet. The data reflect that a professor can have multiple advisees, can serve on multiple committees, and can edit more than one journal. Use the dependency diagram shown in Figure 6.8 to work the following problems. Suppose you are given the following business rules to form the basis for a database design. The database must enable the manager of a company dinner club to mail invitations to the club’s members, to plan the meals, to keep track of who attends the dinners, and so on. The table structure shown in Table P6.6 contains many unsatisfactory components and characteristics. For example, there are several multivalued attributes, naming conventions are violated, and some attributes are not atomic. To keep track of office furniture, computers, printers, and so on, the FOUNDIT company uses the table structure shown in Table P6.5. Using the STUDENT table structure shown in Table P6.4, do the following: Using the INVOICE table structure shown in Table P6.3, do the following: Using the descriptions of the attributes given in the figure, convert the ERD shown in Figure P6.2 into a dependency diagram that is in at least 3NF. Using the descriptions of the attributes given in the figure, convert the ERD shown in Figure P6.1 into a dependency diagram that is in at least 3NF. A table is in 3rd _ normal form when it is in 2nd normal form and there are no transitive dependencies.
Old Questions

Coming Soon

Top