Question
In: Computer Science
You are to design a database for the upcoming Greater Wisconsin River Fishing Contest. Consider the...
You are to design a database for the upcoming Greater Wisconsin River Fishing Contest. Consider the following functional dependencies;
- SportsPersonId --> SportsPersonFirstName, SportsPersonLastName
- SportsPersonId --> Address
- SportsPersonId --> BoatId
- BoatId --> MotorMake
- FishId --> SpeciesOfFish, Weight, Length
- SportsPersonId + FishId --> DateTimeCaught
Please note the following;
- This is a “catch and release” contest meaning that once a fish is caught, the specifics are collected, the fish is safely tagged with a unique id, and then is released back to the river. One fish might be caught by numerous sports persons but a sports person can only register the catch of a fish no more than one time.
- Each Sports Person must be assigned a boat and a boat can be assigned to multiple sports persons.
Create an ERD in 3NF for these relations. Create appropriate table names for the ERD. Include all applicable fields based on information you have been given and underline the Primary or Composite Primary Key fields. Make sure to include the correct ERD diagram symbols between tables to show the proper relationship type (e.g. 1:1, 1:M, etc.)
Solutions
venereology answered 1 day agoRelated Solutions
Consider the following information to design a database for a catalogue of an online video service...
Consider the following information to design a database for a
catalogue of an online video service that offers access to popular
TV series.
The following is the description of
the application:
Each series has a name and a description.
Each series has many episodes. Each episode of a series has an
episode number, the date it was first aired, and the length of the
episode in minutes. The episode number uniquely identifies an
episode with respect to the series, but...
The owner of Horne Design Wallcoverings has hired you as a consultant to design a database...
The owner of Horne
Design Wallcoverings has hired you as a consultant to design a
database management system for his chain of three stores that sell
wallpaper and accessories. He would like to track sales, customers
and employees. After initial meeting with him, you have developed a
list of business rules and specifications to begin the design of an
E-R Model. The list of business rules are:
Customers place orders through a branch
A customer may place many orders
A...
Database You have just started a new position on the database design staff at Gizmonic Consultants,...
Database
You have just started a new position on the database design
staff at Gizmonic Consultants, Inc.
Your first project is to translate the database requirements for
Continental Hotels into an ER representation. In the next project,
you will derive a relational schema from an ER diagram and
implement the schema, populate it, and query over it.
Requirements:
Develop an ERD to capture the entities and relationships
specified in the requirements documentation below. Use only the
conventions covered in class....
You are hired to design a database for a fitness center. As the fitness center is...
You are hired to design a database for a fitness center. As the
fitness center is expanding with more than one branch, they want to
create a database to keep track of its customers, facilities and
employees. Each branch has a unique id and address (building
number, street, district, and city). A branch may have more than
one facility (e.g. swimming pool, spa, etc.). Each facility must
belong to only one branch, and the information for a facility is
name...
You are hired to design a database for a fitness center. As the fitness center is...
You are hired to design a database for a fitness center. As the
fitness center is expanding with more than one branch, they want to
create a database to keep track of its customers, facilities and
employees. Each branch has a unique id and address (building
number, street, district, and city). A branch may have more than
one facility (e.g. swimming pool, spa, etc.). Each facility must
belong to only one branch, and the information for a facility is
name...
You are a data analyst with strong backgrounds in database design and management. In fact, you...
You are a data analyst with strong backgrounds in database
design and management. In fact, you have learned from education,
mentors, and experience the art of collecting data and transforming
data into business intelligence and your experience in database
design and management complements your abilities to analyze data.
Your hypothetical employer, Park University, is in the process
planning a new employee payroll database and has asked you for
assistance. The database will be standalone but will need to have
ability...
You need to design a Web Server, Database Server and a Backup server. If you had...
You need to design a Web Server, Database
Server and a Backup server.
If you had to choose from the following list of resources which
ones would you place a priority on and state why you would do so.
List these for each server type. Hint: You need to think about the
functionality of the server. Based on this information, which
resource would you emphasize on the most to increase the
performance of the server.
CPU utilization and speed
Multiprocessing...
You are asked to design a relational database for a simple course registration software application for...
You are asked to design a relational database for a simple
course registration software application for your school. The
relational database must have the following information about the
student, the course, and the registration, respectively
StudentID, FirstName, LastName, DataOfJoining, and Major
CourseNumber, CourseName,InstructorName, StartDate, EndDate,
NumberOfCredits
ReferenceID, StudentID,CourseID, DateOfRegistration
Apply the following constrains while designing the database
Each student in the database must be uniquely identifiable
Each course listed in the database must be have unique
CourseNumber
Each course registration...
You have been accepted as an intern at an IT start-up. In a database design session,...
You have been accepted as an intern at an IT start-up. In a
database design session, you see that phone number, post code and
some other attributes have been defined as numeric datatype. Do you
think it is the correct decision? If not, suggest the reasons why
this is not appropriate.
You are asked to design a database to support a Instant Recruitment System of casual staff...
You are asked to design a database to support a Instant
Recruitment System of casual staff for a school. The major business
requirements are summarised below in the Mini Case: An Instant
Recruitment System. You are asked to develop a detailed
Entity-Relationship model for this mini case. Your ER model should
consist of a detailed ER diagram integrated with itemised
discussions on the features of the entities and relationships and
all the assumptions you made where applicable. The ER diagram...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- A major advantage of the corporation relative to other forms of business organization is
- A fictional company has been producing propene oxide, C3H6O, from propene, C3H6, with a 96.0% yield....
- Create two files, file1.csv and file2.csv Write the following information in file1.csv: Apple 1.69 001 Banana...
- When reading a legal text, the first rule to apply is the: Literal Rule. Golden Rule....
- Please fix this python script, I keep getting a return outside function error and cannot get...
- Calculate (a) the saturation magnetization and (b) the saturation flux density for nickel, which has a...
- Create a complete java program called Week_Report. The program must include two array structures, a string...
ADVERTISEMENT