677343.docx - Use this Template for the DS Assignment...

Info icon This preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Use this Template for the DS Assignment Please note that you can modify this template to suit your own presentation This is only a sample, you should make sure all aspects of your work and assessment tasks are clearly evidenced You should also check Assignment Deliverables should in the Assessment guide and the marking schema. Title : Database Design Student Name: Student id: 1
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
1.EERM 1.1 Assumptions The following assumptions are made before the construction of the Extended ER Diagram : It is assumed that there are only two types of staffs, the Stage Staffs and the Security Staffs. They can be easily generalized to an Entity named staffs. It is assumed that a single venue is hired for a single festival and single venue is located at a single location. It is assumed that the Location is the weak entity for the strong entity type Venue and Stage_Staffs and Security_Staffs are the weak entities for the strong entity type Staffs. It is assumed that a single venue contains a single stage. And hence stage is a weak entity for the strong entity venue. 1.2 Extended Entity Relationship Diagram (EER Diagram) Entity Relationship Diagram Bands Festivals Venue Organizer Staffs Equipments Security_Staffs Stage_Staffs Location Event performs has hired for organizes located at works for hired for Stage contains Figure: EERD Source: (created by author) 1.3 List your attributes and identifiers here: Bands (BandId, Band_Name, Genre) Festivals (FestID, FestName, VenueID, OrganizerID) Event (EventID, EventName, FestID, BandId, Attendence, EquipmentID) Equipments (EquipmentID, EquipmentName) Organizers (OrganizerID, OrganizerName, StaffID) Venue (VenueId, Name, LocationName, Country, Contact_Person) Location (LocationName, Country) Staffs (StaffId, Name) 2
Image of page 2
Stage_Staffs (StaffId, StaffName, Wage) Security_Staffs (StaffId, StaffName, HiringCost) Stage (StageID, VenueId) 1.4 Include a list of the Validation Questions of your model here: Details for each Festival and the key organizer of the Festival Details of Venues and Locations where the festival is taking place Name of the Contact person for the Venue List of all staff working at the Festival List of Bands playing at Festival A list of bands on each location, times and dates Details of allocation of staff to a stage Equipment list for each stage Security staff allocated to a venue and each stage 1.5 A definition for each entity Bands: The information about all the bands performing in the festivals are provided here.
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern