Please follow the instruction
Carl H. Lindner College of Business
University of Cincinnati
IS-3030 Database Design
Homework Assignment #1: Conceptual Data Modeling
Based on the following narrative description, conduct the conceptual data modeling and draw an
Entity-Relationship diagram according to the requirements. You should specify the identifier and
other non-key attributes for each entity type. For relationship types, you should specify: (1) the
(min, max) cardinality ratios (you can use any representation notation), and (2) the relationship
attributes if it is appropriate to include them.
Tokyo 2020 Summer Olympics
You have been asked by the International Olympic Committee (IOC) to design a database for the
2020 Summer Olympics in Tokyo, Japan. IOC wants to keep track of information for each
participating country such as name, population, team color, continent, nation-anthem, the contact
person and the number of participants. Each participating country consists of athletes, referees
and delegates. IOC wants to keep track of information for all delegates such as passport#, name,
gender, title, and birthday.
For each athlete, IOC wants to keep track of the A#, passport#, name, birthday, gender, height,
years of participation and weight. For each referee, IOC wants to keep track of the passport#,
referee#, name, birthday, gender, years-of-participation, and areas-of-expertise.
Several games happen during the Summer Olympics. An example of a game is the men’s 400
meter. A game has several heats. IOC needs to keep track of the details of each heat. Heat
details include heat#, game name, and the number of athletes who participate in each heat. An
athlete can participate in many heats but must participate in at least one. You must record the
results of each athlete in each heat. The details for each athlete in each heat include the athlete’s
time and rank. In addition, you must record the winners (Gold, Silver, and Bronze) of each
game.
Referees are assigned to heats. Each heat should have at least one referee and a referee can be
assigned to more than heat. Heats are held in different facilities (e.g., Track & Field Arena) on
different dates. The detailed information of each facility such as name, location, capacity, ower
and available transportation services must be recorded for reference.
Note:
The specifications given above are quite comprehensive, but of course not complete. If you need
clarification or additional information, please feel free to ask the instructor. Another option is to
make reasonable assumptions and state them to support your conceptual data modeling. None of
the assumptions you make can nullify or contradict the business rules stated above.
Deliverable:
Entity-Relationship diagram of your conceptual data modeling (I will not accept late homework.)
It is preferable to draw your ER diagram using a software tool (e.g., MS Visio).
This is an individual homework assignment.
IS-3030
Database Design
You and your classmates would like to set up your own business by developing an Electronic Auction Web site (e.g., for the staff, faculty and students of University of Cincinnati). According to your understanding of database concepts, you would like to build a database to support the operations of this auction web site. To run your business, you need to keep track of the transactions, specifically, the items that are offered to be auctioned, the person offering the item, and bids and ask prices. In order for any customer (a buyer or a seller) to be able to conduct business on your web site, he or she must set up an account with payment methods and personal details (such as, name, email address, phone, gender, birthday, address, etc.). After the account is established, he or she can offer items for auction or buy auction items. A customer can offer many items for auction.
However, everyone can offer bids along with his or her name, telephone number and email without creating an account. For each auction item, you want to keep certain information such as the ask price, the bids, the final sale price, and the categories that it belong to. The seller must assign each offered item to at least one category, and up to five categories.
Your database should answer the following queries in order to run the auction business. You should consider the information needs as data requirements in your conceptual data modeling.
1. What is the name of the buyer who bought Item#123456789, on what date, and at what price?
2. List the Item# for all items which has been registered on July 4 9, 2016.
3. List the names, phone and account numbers of sellers who have registered item with ask price less than $100.
4. List the account opened-date, name, email, address, and number of items under auction by the customer whose name is Nancy Wilson.
5. List the names, emails and bids for the Item#123456789.
6. List the dates that the auction opens and closes for Item#123456789.
7. List the name, telephone umber, and email for all the bidders that offer the bid as the ask price for item#598979975.
8. List the number of items that under each category of items for auction.
9. List the Item# and description for all items that under the category with type ‘custom textbook’.
10. List the names and emails of the buyers who bought items listed in the ‘Exercise equipment’ category.
One of the challenges for database designers is to represent and communicate their understanding of data requirements to end users. On a single sheet of paper, draw an Entity-Relationship (ER) diagram that you will use to represent and communicate your understanding of the data requirements of this E-Auction.
1. What entities are relevant?
2. What attributes are relevant (indicate if its an identifier, derived, etcetera)?
3. What relationships are relevant? Indicate degrees and whether its an “Is-A” or “Has-A.”
4. Draw the entire model on the back.
Conceptual Data Modeling Workshop
birthday
title
gender
Passport
Name
Delegates
Essay Writing Service Features
Our Experience
No matter how complex your assignment is, we can find the right professional for your specific task. Achiever Papers is an essay writing company that hires only the smartest minds to help you with your projects. Our expertise allows us to provide students with high-quality academic writing, editing & proofreading services.
Free Features
Free revision policy
$10Free bibliography & reference
$8Free title page
$8Free formatting
$8How Our Dissertation Writing Service Works
First, you will need to complete an order form. It's not difficult but, if anything is unclear, you may always chat with us so that we can guide you through it. On the order form, you will need to include some basic information concerning your order: subject, topic, number of pages, etc. We also encourage our clients to upload any relevant information or sources that will help.
Complete the order form
Once we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.
Writer’s assignment
As soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.
Completing the order and download