HomeworkLib
Question

The Prep-Prep school wishes to add tracking student participation in sports to their database. They will...

The Prep-Prep school wishes to add tracking student participation in sports to their database.

They will add a new entity called Sport to their database. Each entry will have Sport# as its primary key and will record one term’s participation in one sport for one student,

The attributes of Sport will include

StudentNumber   this is the <PK> to Student

Sport name e.g. swimming

School term e.g. winter2017

Draw an ERD showing these entities.

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

We have two entities :-

1) Sport - 4 attributes given

2) Student - only PK is mentioned.

There is one to one relation between both entities. (Given : one sport for one student)

3) Participation - as relation between both entities.

Entities Attribute
Sport Sport#(PK), StudentNumber(FK), Sport name, School term
Student StudentNumber

ERD

Attributes are in oval shape.

Relation in diamond shape in ERD.

Entities are in rectangle shape.

Feel free to ask any query further.

0 0
Add a comment
Know the answer?
Add Answer to:
The Prep-Prep school wishes to add tracking student participation in sports to their database. They will...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • QUESTION 1 What is the most common relationship within a relational database? Select the best answer...

    QUESTION 1 What is the most common relationship within a relational database? Select the best answer from the following. One-To-One relationship. o One-To-Many relationship. Many-To-Many relationship. Zero-To-Zero relationship. QUESTION 2 What is an "entity'? Select the best answer from the following. An entity, for our purposes, is the same as a table in the database. An entity represents one of the columns in an individual table. There are no entities in a relational database. Entities are only part of NoSQL...

  • Question 4. ER model (5 points). You are asked to design the ER diagram for a database to manage ...

    Question 4. ER model (5 points). You are asked to design the ER diagram for a database to manage data for athletes athletic game. Requirements are as follows: Each participating team has a name and a manager. Each athlete has a unique athlete ID, and is also described by first name and last name, gender and age. A team has many athletes but an athlete only belongs to one team. Each sport has a unique code and some sport name....

  • DRAW THE ERD(CDM) AND GENERATE THE RELATIONAL TABLE (PDM) USING POWER DESIGNER. PLEASE COMPLETE EACH ENTITY...

    DRAW THE ERD(CDM) AND GENERATE THE RELATIONAL TABLE (PDM) USING POWER DESIGNER. PLEASE COMPLETE EACH ENTITY WITH ATTRIBUTES INCLUDING PRIMARY KEY AND FOREIGN KEY CONSTRAINTS PROBLEM 3 - Draw an entity-relationship diagram for the following scenario, stating any assumptions you find it necessary to make, and showing unknown cardinalities and optionalities using question marks on the relationship line. Show also the attributes explicitly mentioned in the scenario and underline any you consider suitable candidates for being primary keys. It is...

  • Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for each course.

    Question: Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for each course. 1- Draw an ER diagram of ONLINE COURSE REGISRATION database, that captures all the given below requirements. Specify key attribute(s) of each entity set. For each relationship set, specify structural constraints and participation constraints. a. For each USER, the portal maintains user ID, Name, E-mail. Each user has a unique ID. Name is a Composite attributes with Frame, Midname,...

  • This is a database with two tables relating to students at a school. Each student has...

    This is a database with two tables relating to students at a school. Each student has a unique ID. There is a backlog table that maintains a record of active backlogs for each student. Write a query my oracle sql to print the names of the students who have at least one active backlog. The names should be printed in ascending order.The results should be in the following format: NAME Note: There could be students with the same name but...

  • Question 1 4 Marks A sports center aims to setup a database to maintain the following...

    Question 1 4 Marks A sports center aims to setup a database to maintain the following information. The database stores the name, the address and a unique ID of each employee. The employees are classified into three categories: trainers, receptionists and administrators. Each trainer has one or more specialties (eg, swimming, tennis and squash ete). Each receptionist can be reached through a landline phone number. Each receptionist must be supervised by one administrator and a administrator may supervise multiple receptionists....

  • c) Write an ER Diagram for the following Library database. Identify all the Entities, Relationships and Attributes. Underline the primary keys and mark the different constraints. You can add an I att...

    c) Write an ER Diagram for the following Library database. Identify all the Entities, Relationships and Attributes. Underline the primary keys and mark the different constraints. You can add an I attribute as a primary key for an entity to make t unique if necessary. Library has a number of branches in the city, each branch having a name, address and librarian. Books have title, authors and publisher. A book can have multiple authors but a single publisher. Note that same...

  • What’s A Matter University (good old Whatsamatter U) is developing a database to manage academic issues....

    What’s A Matter University (good old Whatsamatter U) is developing a database to manage academic issues. You are asked to assist in the design of the database. Sketch the Entity-Relationship diagram for each of the following business needs. Your answer must adhere to the following guidelines: a)    You need to provide a separate E-R diagram for each of the questions, not a single diagram that addresses all five questions; b)    Although each question is to be answered with a separate...

  • Mr. Bob Dillon is a collector of china pieces. He needs a database is to store...

    Mr. Bob Dillon is a collector of china pieces. He needs a database is to store data about his collection. Each piece in this collection is to be identified by a unique ID value. Bob knows of several agents that work on getting these pieces shown in prestigious exhibitions. Each exhibition has an ID, a name, a venue, a start date and an end date. For all items shown, there is a deadline for returning them to the item owners....

  • you are required to develop a simple HR application for a small accounting firm that wishes...

    you are required to develop a simple HR application for a small accounting firm that wishes to keep track of all the employees at the firm; storing details about their salary, phone numbers and Date of Birth. The firm has many departments and there are 5 to 20 employees in each department. The department information includes department name, description and total number of employees in that department. The company also provides vehicles for some of its employees. An employee maybe...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT