Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello, i need help with my Assignment. I will upload a part where there has to be an ERD diagram included by using Crow foots
Hello, i need help with my Assignment. I will upload a part where there has to be an ERD diagram included by using Crow foots notation. For the answer, a screenshot of the outcome would be very helpful!
PART I. CONCEPTUAL DATABASE MODEL (60%) ABC inc. has contacted you to create a database for their conference schedule and registration. A sample of a conference schedule is provided in the appendix. Through interviews with the manager, you obtain the following information: ABC inc. runs a conference named "Connect" yearly. The conference takes place on a specific date, and a specific location. The day and place of the conference may vary over years. ABC inc. needs to keep track of the conference name, date (e.g. Jan 16, 2020), location (San Diego convention center) and the address (111 W Harbor Dr, San Diego, CA 92101, United States). The conference runs multiple tracks where each track has a specific topic's name (e.g. Government, Learning center track, Big Data) and a specific room number. One Track belongs to one and only one scheduled conference. Each track consists of multiple presentations. A presentation can belong to one and only one track. Each presentation has a title, start time and end time. Each presentation is presented by one or more presenters. A presenter presents one or more presentations. A presenter is identified with first and last name and company name. One the conference schedule provided in the appendix, some presenters names are followed by the company names in parentheses (e.g. Chulsu Ha (SOCAR)). When the company name is not mentioned, the presenters works for ABC inc. Design a conceptual database model without redundancy for the above company. Draw the ERD using Microsoft Visio (choose Crow's Foot Diagram). Include the following in your assignment document: The ERD A list of business rules that you assumed for drawing your ERD (only if not clearly specified above). In the real world, you would go back to the manager to confirm if your assumptions are correctStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started