Database Modeling & Design Fourth Edition- P55: Database technology has evolved rapidly in the three decades since the rise and eventual dominance of relational database systems. While many specialized database systems (object-oriented, spatial, multimedia, etc.) have found substantial user communities in the science and engineering fields, relational systems remain the dominant database technology for business enterprises. | Exercises 257 Given table R A B C and the set R1 A B R2 B C satisfies the lossless decomposition property 1. Does the multivalued dependency B- C hold 2. Is B a candidate key 3. Is R in 4NF Given a table skills_available with attributes empno project and skill in which the semantics of skills_available state that every skill an employee has must be used on every project that employee works on 1. Is the level of normalization of skills_available at least 4NF 2. Given table R A B C with actual data shown below a. Does the multivalued dependency B- C hold b. Is R in 5NF R A B C w x p w x q z x p z x q w y q z y p Logical Database Design Generic Problem Problem 7-1 Design and implement a small database that will be useful to your company or student organization. 1. State the purpose of the database in a few sentences. 2. Construct an ER or UML class diagram for the database. 3. Transform your ER or UML diagram into a working database with five to ten rows per table of data you can make up to fit the data 258 Exercises base schema. You should have at least four tables enough to have some interesting queries. Use Oracle DB2 SQL Server Access or any other database system. 4. Show that your database is normalized BCNF using FDs derived from your ER diagram and from personal knowledge of the data. Analyze the FDs for each table separately this simplifies the process . 5. Demonstrate your working database by displaying the results of four queries. Pick interesting and complex queries impress us . OLAP Problem 8-1 As mentioned in Chapter 8 hypercube lattice structures are a specialization of product graphs. Figure shows an example of a three-dimensional hypercube lattice structure. Figure shows an example of a two-dimensional product graph. Notice that the two figures are written using different notations. Write the hypercube lattice structure in Figure using the product graph notation introduced with Figure . Keep the same dimension order. Don t worry .
