Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
The university has appointed Dr. Sami as the director of the intramural department. Dr. Sami has hired you to develop and maintain the database that will manage the departmental activities and produce the required reports. Because the intramural department is new, Dr. Sami is not yet certain of the data the department needs to collect and manage. Initially, he wants the database to manage data about each sport offered by the intramural department (including team assignments, coaches, and scheduling), the students who sign up for sports teams, and the equipment. Because you are the only person responsible for the database, there is a lot of responsibility on your shoulders to provide a database that works well for the department. Complete the following:

The university has appointed Dr. Sami as the director of the intramural department. Dr. Sami has hired you to develop and maintain the database that will manage the departmental activities and produce the required reports. Because the intramural department is new, Dr. Sami is not yet certain of the data the department needs to collect and manage. Initially, he wants the database to manage data about each sport offered by the intramural department (including team assignments, coaches, and scheduling), the students who sign up for sports teams, and the equipment. Because you are the only person responsible for the database, there is a lot of responsibility on your shoulders to provide a database that works well for the department. Complete the following:

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question
100%

can you help me with the following database question? I have attached them below.

The university has appointed Dr. Sami as the director of the intramural department. Dr. Sami has hired you to develop and maintain the database that will manage the departmental activities and produce the required reports. Because the intramural department is new, Dr. Sami is not yet certain of the data the department needs to collect and manage. Initially, he wants the database to manage data about each sport offered by the intramural department (including team assignments, coaches, and scheduling), the students who sign up for sports teams, and the equipment. Because you are the only person responsible for the database, there is a lot of responsibility on your shoulders to provide a database that works well for the department. Complete the following: 1. Dr.Sami decides that the best way to get started planning the database is to prepare a list of all the data items that are needed to support the department. The table on the next page shows his list, which he asks you to use when planning the database. You will need to identify the data to collect, attribute and entities. Item Description
Transcribed Image Text:The university has appointed Dr. Sami as the director of the intramural department. Dr. Sami has hired you to develop and maintain the database that will manage the departmental activities and produce the required reports. Because the intramural department is new, Dr. Sami is not yet certain of the data the department needs to collect and manage. Initially, he wants the database to manage data about each sport offered by the intramural department (including team assignments, coaches, and scheduling), the students who sign up for sports teams, and the equipment. Because you are the only person responsible for the database, there is a lot of responsibility on your shoulders to provide a database that works well for the department. Complete the following: 1. Dr.Sami decides that the best way to get started planning the database is to prepare a list of all the data items that are needed to support the department. The table on the next page shows his list, which he asks you to use when planning the database. You will need to identify the data to collect, attribute and entities. Item Description
Database Concepts ITC 230 Assignment 2&3 Students: We need to store information about students who participate on teams and the sports in which they participate, including the team. Students can sign up for more than one sport. Student and faculty IDs at AUAF are five digits. ID number Name First and last names. Home phone number, cell phone number. Students must sign a waiver to play on a team; we must have this document on Phone Waiver file. Academic eligibility Students must be academically eligible to play sports by maintaining a C or better grade point average; we must check eligibility at registration. Sports Sports including basketball, football, ping pong, pool, soccer, softball, swimming, tennis, track, and wrestling. Each sport has an assigned coach. We need to know the coach's name, office number (such as BIT-231), office phone number, and cell phone number. A Name Соach person can coach one or more teams over one or more seasons. Min and max players Each sport has a designated minimum and maximum number of players. Begin date The date each sport begins. A place to record notes about each sport. Notes Equipment: Teams or coaches check out the equipment they need for their sport's practice sessions. ID number Equipment is assigned an ID number using a sport abbreviation and a number (BAS = basketball, FTBL = football, PNG = ping pong, POL = pool, SOC = soccer, SOF = softball, and TEN = tennis). For example, BAS-1 is a basketball. Some equipment ID numbers indicate a collection of items. For example, BASBAG-3 is three basketballs. Description Storage building Fields: Different courts, fields, and tables are available for practice and A description of the equipment. The building where the equipment is stored, such as SB-1. games. ID number Courts, fields, and tables are assigned ID numbers. For example, BAS-CRT-1 is a basketball court, SOC-FLD-2 is a soccer field, and POL-TBL-2 is a pool table. Identify the court field, or table type (basketball, softball, and so on). Each court, field, and table has an assigned maintenance person, who manages and resolves problems with the court, field, or location. We will need to know the maintenance person's name, phone number, and office number. The seasons each field is available for use by a team (some fields are unavailable Туре Maintenance contact Season off-season for maintenance purposes). The seasons are fall and spring; some sports run year-round, in which case the season is "always". Teams: For each team, we need to know the team number, captain, sport name, location where games are played, and the equipment needed for the game. 2. For each entity you identified, determine the data type to assign to each field, and which attributes to use as the primary key.
Transcribed Image Text:Database Concepts ITC 230 Assignment 2&3 Students: We need to store information about students who participate on teams and the sports in which they participate, including the team. Students can sign up for more than one sport. Student and faculty IDs at AUAF are five digits. ID number Name First and last names. Home phone number, cell phone number. Students must sign a waiver to play on a team; we must have this document on Phone Waiver file. Academic eligibility Students must be academically eligible to play sports by maintaining a C or better grade point average; we must check eligibility at registration. Sports Sports including basketball, football, ping pong, pool, soccer, softball, swimming, tennis, track, and wrestling. Each sport has an assigned coach. We need to know the coach's name, office number (such as BIT-231), office phone number, and cell phone number. A Name Соach person can coach one or more teams over one or more seasons. Min and max players Each sport has a designated minimum and maximum number of players. Begin date The date each sport begins. A place to record notes about each sport. Notes Equipment: Teams or coaches check out the equipment they need for their sport's practice sessions. ID number Equipment is assigned an ID number using a sport abbreviation and a number (BAS = basketball, FTBL = football, PNG = ping pong, POL = pool, SOC = soccer, SOF = softball, and TEN = tennis). For example, BAS-1 is a basketball. Some equipment ID numbers indicate a collection of items. For example, BASBAG-3 is three basketballs. Description Storage building Fields: Different courts, fields, and tables are available for practice and A description of the equipment. The building where the equipment is stored, such as SB-1. games. ID number Courts, fields, and tables are assigned ID numbers. For example, BAS-CRT-1 is a basketball court, SOC-FLD-2 is a soccer field, and POL-TBL-2 is a pool table. Identify the court field, or table type (basketball, softball, and so on). Each court, field, and table has an assigned maintenance person, who manages and resolves problems with the court, field, or location. We will need to know the maintenance person's name, phone number, and office number. The seasons each field is available for use by a team (some fields are unavailable Туре Maintenance contact Season off-season for maintenance purposes). The seasons are fall and spring; some sports run year-round, in which case the season is "always". Teams: For each team, we need to know the team number, captain, sport name, location where games are played, and the equipment needed for the game. 2. For each entity you identified, determine the data type to assign to each field, and which attributes to use as the primary key.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS