Create a visual representation of your database design

Assignment Help Management Information Sys

Reference no: EM132119496

GARDEN GLORY PROJECT QUESTIONS

Convert the data model you constructed for Garden Glory in part B at the end of Chapter 4 (or an equivalent data model that your instructor provides for you to use) into a relational database design for Garden Glory. Document your database design as follows.

A. Specify tables, primary keys, and foreign keys. Using Figures 5.26 and 5-28 as guides, specify column properties.

B. Describe how you have represented weak entities, if any exist.

C. Describe how you have represented supertype and subtype entities, if any exist.

D. Create a visual representation of your database design as an IL Crow's Foot BA dia-gram similar to the one in Figure 5-27.

E. Document referential integrity constraint enforcement, using Figure 5-29 as a guide.

F. Document any business rules that you think might be important.

G. Describe how you would validate that your design is a good representation of the data model on which it is based.

Reference no: EM132119496

Questions Cloud

What is the magnitude of the force : If the first person is pulling with a magnitude of F1=233.9 N of force and the second force is exerting a force of F2=2212.9N, what is the magnitude.

Analyse processes involved in managing investment portfolio : FIN206 - Investment Management - Explain the theoretical concepts underpinning investment management - Discuss the benefits and costs of moving

What do you think is our main or primary source of knowledge : What do you think is our main or primary source of knowledge: reason, sense experience, or both? What do you think is more real.

Was it good to be an american farmer : Was it good to be an American farmer in the late 19th century (1875-1900)? Note the precise geographic regions you include. Be specific and detailed with your.

Create a visual representation of your database design : Create a visual representation of your database design as an IL Crow's Foot BA dia-gram similar to the one in Figure 5-27.

What evidence supports the contention : What evidence supports the contention that the United States was becoming an imperialist world power by the early 20th century (1870-1914).

Find the force required to lift the piano : In raising a 6400-N piano with a pulley system, the movers note that, for every 3.0 m of rope pulled down, the piano rises 0.26 m

Discuss about the previous approaches to the situation : In this discussion topic, please share your topic and audience with your classmates. Please write one or two paragraphs in which you give as much detail.

Outline legal governance issues that affect the organisation : BULAW 5911 MANAGING THE LEGAL ENVIRONMENT ASSIGNMENT - RESEARCH PROJECT. Outline legal governance issues that affect the organisation

User Account

All Pages