Sponsored Links

Results 1 to 1 of 1

Thread: Cs403 Assignment 3 Helping material May 8,2010

  1. #1
    Senior Member viki's Avatar
    Join Date
    May 2010

    Post Cs403 Assignment 3 Helping material May 8,2010

    Sponsored Links1

    10. Create a Crow’s Foot ERD for each of the following descriptions. (Note: The word many merely means “more than one” in the database modeling environment.)

    a. Each of the MegaCo Corporation’s divisions is composed of many departments. Each of those departments 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.

    The Crow’s Foot ERD is shown in Figure T1.20A.

    FIGURE T1.20A The MegaCo Crow’s Foot ERD


    As you discuss the contents of Figure T1.20A, note the 1:1 relationship between the EMPLOYEE and the DEPARTMENT in the “manages” relationship and the 1:M relationship between the DEPARTMENT and the EMPLOYEE in the “is assigned to” relationship.

    b. During some period of time, a customer can rent many videotapes from the BigVid store. Each of the BigVid’s videotapes can be rented to many customers during that period of time.

    The solution is presented in Figure T1.20B. Note the M:N relationship between CUSTOMER and VIDEO. Such a relationship is not implementable in a relational model.

    FIGURE T1.20B The BigVid Crow’s Foot ERD


    If you want to let the students convert Figure T1.20’s ERD into an implementable ERD, add a third RENTAL entity to create a 1:M relationship between CUSTOMER and RENTAL and a 1:M relationship between VIDEO and RENTAL. (Note that such a conversion has been shown in the next problem solution.)

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

    FIGURE T1.20C The Airline Crow’s Foot ERD


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

    The solution is shown in Figure T1.20D.

    FIGURE T1.20D The KwikTite Crow’s Foot ERD


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

    The solution is shown in Figure T1.20E.

    FIGURE T1.20E The Earned Degree Crow’s Foot ERD


    Note that this M:N relationship must be broken up into two 1:M relationships before it can be implemented in a relational database. Use the Airline ERD’s decomposition in Figure T1.20C as the focal point in your discussion.
    [B]The more knowledge you have, the greater will be your fear of Allah.[/B]

    Please Join My [B]Group Vuhelp[/B][B], Birthday Wishing, Daily Hadees[/B] [CODE][B]http://vuhelp.net/groups/vuhelp.html[/B]
    [CENTER][B][COLOR="Red"][SIZE="4"]Email: [email]viki@vuhelp.net[/email][/SIZE][/COLOR][/B][/CENTER]

  2. #2
    Junior Member
    Join Date
    Apr 2020
    The online learning system is very good thing sometimes because the student feels very happy to perform better detail about it. Get help from my assignment help australia so that you will be keeping the detailed version at all.

    Sponsored Links

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 02-03-2012, 04:32 PM
  2. Replies: 0
    Last Post: 08-12-2010, 09:38 PM
  3. MKT630 GDB Helping Material 28 July 2010
    By viki in forum GDB Discussion
    Replies: 0
    Last Post: 07-28-2010, 06:06 AM
  4. Fin621 assignment no 2 helping material
    By marjan in forum Assignments & Solutions
    Replies: 9
    Last Post: 07-21-2010, 05:35 PM
  5. CS604 Assignment Helping Material July 2010
    By viki in forum Assignments & Solutions
    Replies: 0
    Last Post: 07-09-2010, 12:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
-: Vuhelp Disclaimer :-
None of the files shown here are hosted or transmitted by this server. The links are provided solely by this site's users. The administrator's or staff of Vuhelp.net cannot be held responsible for what its users post, or any other actions of its users. You may not use this site to distribute or download any material when you do not have the legal rights to do so. It is your own responsibility to adhere to these terms. If you have any doubts about legality of content or you have any suspicions, feel free to contact us.
Online Education | JhelumSoft