Questions from Database Systems


Q: Design and verify a database application for one of your local not

Design and verify a database application for one of your local not-for-profit organizations (for example, the Red Cross, the Salvation Army, your church, mosque, or synagogue). Create a data dictionar...

See Answer

Q: Using the information given in the physical design section (C.

Using the information given in the physical design section (C.5), estimate the space requirements for the following entities: RESERVATION INV_TRANS TR_ITEM LOG ITEM INV_TYPE (Hint: You may want to che...

See Answer

Q: Convert the following relational database tables to the equivalent OO conceptual representation

Convert the following relational database tables to the equivalent OO conceptual representation. Explain each of your conversions with the help of a diagram. (Note: The RRE Trucking Company database...

See Answer

Q: Using the tables in Figure PG.1 as a source of

Using the tables in Figure PG.1 as a source of information: a. Define the implied business rules for the relationships. b. Using your best judgment, choose the type of participation of the entities in...

See Answer

Q: Using the data presented in Problem 1, develop an object space

Using the data presented in Problem 1, develop an object space diagram representing the object's state for the instances of TRUCK listed below. Label each component clearly with proper OIDs and attrib...

See Answer

Q: Given the information in Problem 1, define a superclass VEHICLE for

Given the information in Problem 1, define a superclass VEHICLE for the TRUCK class. Redraw the object space you developed in Problem 3, taking into consideration the new superclass that you just adde...

See Answer

Q: Assume the following business rules: • A course contains many

Assume the following business rules: • A course contains many Sections, but each Section references only one course. • A Section is taught by one professor, but each professor may teach one or more di...

See Answer

Q: Convert the following relational database tables to the equivalent OO conceptual representation

Convert the following relational database tables to the equivalent OO conceptual representation. Explain each of your conversions with the help of a diagram. (Note: The R&C Stores database inclu...

See Answer

Q: Why may client/server computing be considered an evolutionary, rather

Why may client/server computing be considered an evolutionary, rather than a revolutionary, change?

See Answer

Q: Convert the following relational database tables to the equivalent OO conceptual representation

Convert the following relational database tables to the equivalent OO conceptual representation. Explain each of your conversions with the help of a diagram. ) Note: The Avion Sales database includes...

See Answer