[Solved]1 Using Er Diagram Create Database Using Sql Server 2 Populate Sample Data 3 Make Sure Sta Q37189921
1. Using the ER Diagram below, create a database using SQLserver. 2. Populate with sample data. 3. Make sure the statedrequirements are met.
Ace Communications has hired you as an independent consultant tobuild a new database using their existing SQL Server software. ACECommunications runs conferences for various trade organizations(customers). The conferences are generally held in a city and hotelof their customers choosing. Each conference has various sessionsthat the attendees of the conference can enroll in. ACE needs adatabase to maintain information about their customers,conferences, sessions, and attendees. The customer informationwould include the name of the company as well as the contact name,address information, and phone information. A customer may haveemployed ACE for many conferences. The conference information wouldinclude the customer, the name of the conference, the date(s) ofthe conference, the hotel name, and the city where the hotel islocated. The session information would include the topic, thespeaker(s), the room in the hotel where the session is takingplace, and the date/time of the session. Each session may have morethan one speaker. Keep in mind that sessions are related to aparticular conference. The attendee information would include thename of the attendee and the sessions that they have enrolled infor a particular conference. Each attendee can enroll in as manysessions as they want. Some of the other goals that ACE wants toaccomplish with their database include: • Need to know theattendees for each session at a particular conference. • Need toknow the speakers for each session at a particular conference. •Need to know the speaker that each attendee has seen at any sessionfor a particular conference.
Customer CustID CompanyName ContactName ContAddress Cont _Phone Attendee Conferences attendeeID Name ConfID CustName ConfName Date HotelName City CustID Speaker SpeakerID SpeakerName Session SessionID Date Time Topic confID AttendeeSession SpeakerSession attendeeID SessionID SpeakerID SessionID Show transcribed image text Customer CustID CompanyName ContactName ContAddress Cont _Phone Attendee Conferences attendeeID Name ConfID CustName ConfName Date HotelName City CustID Speaker SpeakerID SpeakerName Session SessionID Date Time Topic confID AttendeeSession SpeakerSession attendeeID SessionID SpeakerID SessionID
Expert Answer
Answer to 1. Using the ER Diagram below, create a database using SQL server. 2. Populate with sample data. 3. Make sure the stated… . . .
OR
