ABC inc. has contacted you to create a database for their conference schedule and registration. A...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 correct. 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 correct.
Expert Answer:
Answer rating: 100% (QA)
I can certainly guide you through creating a conceptual database model for the given scenario Howeve... View the full answer
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these general management questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
what is OLAP Operations.
-
Googles ease of use and superior search results have propelled the search engine to its num- ber one status, ousting the early dominance of competitors such as WebCrawler and Infos- eek. Even later...
-
Discuss the concept of the Process Spectrum. Use examples where appropriate.
-
In September 2019, Gaertner Corp. commits to selling 150 of its iPhone-compatible docking stations to Better Buy Co. for $15,000 ($100 per product). The stations are delivered to Better Buy over the...
-
Elliot operates his clothing store as a single member LLC (which he reports as a sole proprietorship). In 2022, his proprietorship generates qualified business income of $280,000, he pays W2 wages of...
-
One early morning in the fall of 2007, Dennis Jonsson was reading the latest reports on global warming and thought that someone ought to do something about it. Then he realized that he and his fellow...
-
The Allen Company is a wholesale distributor of automotive replacement parts. Initial amounts taken from Allens accounting records are as follows: Inventory at December 31, 2007 (based on physical...
-
The Branson Corporation is considering a change in its cash-onlypolicy. The new terms would be net one period. The required returnis 2 percent per period. Based on the following information, whatis 2...
-
At the beginning of 2008, Bellamy Seafood acquired equipment costing $60,000. It was estimated that this equipment would have a useful life of six years and a residual value of $6,000 at that time....
-
(2) Carl Bowen worked with First Union Limited for twenty (20) years prior to his redundancy in May 2020. His salary for the last three years is shown below. His total redundancy entitlement is...
-
You work for the Honorable Jane J. Boyle, U.S. District Judge for the Northern District of Texas. She is trying to determine whether the above facts establish that Charlie has a fundamental right to...
-
How do design teams navigate the tension between exploratory experimentation and exploitative refinement in iterative design processes, leveraging techniques such as design sprint methodologies, A/B...
-
Why are interactions, transactions, and interrelationships relevant to Social Work in understanding social dynamics?
-
OkayJanie works at a bank and she put about to go into business with a friend of hers she is concerned about the personal financial stability and has one of your colleagues at the bank look at his...
-
Home mortgage notes are sold on national exchanges similar to the New York Stock Exchange. 1. Does the lending bank have any obligations to the maker of a mortgage note in this regard? 2. Does a...
-
In a series of 18 coin tosses, what is the most likely number of heads? (Show your multiplication)
-
For the following exercises, find the inverse of the function and graph both the function and its inverse. f(x) = 4 x 2 , x 0
-
The Newburg Flyers operate a major sports franchise from a building in downtown Newburg. The building was built in 1940 at a cost of $5,000,000 and is fully depreciated so that it is shown on the...
-
The information below pertains to July production at Porter Company's paint factory, which produces paints for household interiors: Using the weighted-average method, determine the number of...
-
Make-or-buy and opportunity cost Premier Company manufactures gear model G37, which is used in several of its farm-equipment products. Annual production volume of G37 is 20,000 units. Unit costs for...
-
Calculate \(\frac{124}{297}+\frac{3}{125}\).
-
Express \(\frac{252}{840}\) in lowest terms.
-
Calculate \(\frac{21}{40}-\frac{8}{40}\).
Study smarter with the SolutionInn App