10 QUESTIONS-DATABASES

QUESTION #2
Given the business rule(s) you wrote in Problem 1, create the basic Crow’s Foot ERD. 
SEE IMAGE IN LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image013.jpg
Make sure that the file is saved AS ch2_question2_Deleon.doc
————————————————————————————————————————————–
QUESTION #3
 Using the ERD you drew in Problem 2, create the equivalent object representation and UML class diagram. (Use Figure 2.4 as your guide.) 
SEE IMAGE IN LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image017.jpg
Make sure that the file is saved AS ch2_question3_Deleon.doc
—————————————————————————————————————————
 QUESTION #5
The DealCo relational diagram shows the initial entities and attributes for the DealCo stores, which are located in two regions of the country. Create the basic Crow’s Foot ERD for DealCo. 
SEE IMAGE IN LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image019.jpg
Make sure that the file is saved AS ch2_question5_Deleon.doc
——————————————————————————————————————–
QUESTION #7
 The Tiny College relational diagram shows the initial entities and attributes for the college. Create the basic Crow’s Foot ERD for Tiny College. 
SEE IMAGE IN LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image022.jpg
Make sure that the file is saved AS ch2_question7_Deleon.doc
——————————————————————————————————————–
QUESTION #8
 The Tiny College relational diagram shows the initial entities and attributes for the college. Create the UML class diagram that reflects the entities and relationships you identified in the relational diagram. 
SEE IMAGE IN LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image022.jpg
Make sure that the file is saved AS ch2_question8_Deleon.doc
—————————————————————————————————————————
 QUESTION #9
Typically, a hospital patient receives medications that have been ordered by a particular doctor. Because the patient often receives several medications per day, there is a 1:M relationship between PATIENT and ORDER. Similarly, each order can include several medications, creating a 1:M relationship between ORDER and MEDICATION.

a. Identify the business rules for PATIENT, ORDER, and MEDICATION.

b. Create a Crow’s Foot ERD that depicts a relational database model to capture these business rules. 
Make sure that the file is saved AS ch2_question9_Deleon.doc
——————————————————————————————————————————
 QUESTION #11
Using the ERD from Problem 10, create the relational schema. (Create an appropriate collection of attributes for each of the entities. Make sure you use the appropriate naming conventions to name the attributes.) 
 United Broke Artists (UBA) is a broker for not-so-famous artists. UBA maintains a small database to track painters, paintings, and galleries. A painting is created by a particular artist and then exhibited in a particular gallery. A gallery can exhibit many paintings, but each painting can be exhibited in only one gallery. Similarly, a painting is created by a single painter, but each painter can create many paintings. Using PAINTER, PAINTING, and GALLERY, in terms of a relational database: 
Make sure that the file is saved AS ch2_question11_Deleon.doc
———————————————————————————————————-
 QUESTION #12
Convert the ERD from Problem 10 into a corresponding UML class diagram. 
United Broke Artists (UBA) is a broker for not-so-famous artists. UBA maintains a small database to track painters, paintings, and galleries. A painting is created by a particular artist and then exhibited in a particular gallery. A gallery can exhibit many paintings, but each painting can be exhibited in only one gallery. Similarly, a painting is created by a single painter, but each painter can create many paintings. Using PAINTER, PAINTING, and GALLERY, in terms of a relational database: 
Make sure that the file is saved AS ch2_question12_Deleon.doc
———————————————————————————————————————-
QUESTION #14
 Create a Crow’s Foot ERD to include the following business rules for the ProdCo company:

SEE IMAGE IN LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image025.jpg
a. Each sales representative writes many invoices.

b. Each invoice is written by one sales representative.

c. Each sales representative is assigned to one department.

d. Each department has many sales representatives.

e. Each customer can generate many invoices.

f. Each invoice is generated by one customer. 
Make sure that the file is saved AS ch2_question14_Deleon.doc
————————————————————————————————————-
QUESTION #16
 Create a Crow’s Foot ERD for each of the following descriptions. (Note that the word many merely means more than one in the database modeling environment.)
SEE IMAGE IN LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image027.jpg

a. Each of the MegaCo Corporation’s divisions is composed of many departments. Each department has many employees assigned to it, but each employee works for only one department. Each department is managed by one employee, and each of those managers can manage only one department at a time.

b. During some period of time, a customer can download many ebooks from BooksOnline. Each of the ebooks can be downloaded by many customers during that period of time.

c. An airliner can be assigned to fly many flights, but each flight is flown by only one airliner.

d. The KwikTite Corporation operates many factories. Each factory is located in a region, and each region can be “home” to many of KwikTite’s factories. Each factory has many employees, but each employee is employed by only one factory.

e. An employee may have earned many degrees, and each degree may have been earned by many employees. 

Make sure that the file is saved AS ch2_question16_Deleon.doc