Database system to keep track of information

Assignment Help Computer Engineering

Reference no: EM133217900

Choose ONE of the following scenarios:

Scenario 1: The local sports complex offers a variety of youth sports including football, soccer, and basketball. They need a database system to keep track of information about players and their parents, which sport kids have signed up for, teams, coaches, and scheduling/location information.

Scenario 2: The local police station is offering multiple week-long summer camps for teens. These camps offer a variety of activities such as CPR training, sessions in forensics, and various types of physical training activities. They need a database system to keep track of information such as who has enrolled, what activities each teen has signed up for, and instructors and locations for each activity.

Notes:

Each scenario is meant to be vague (which is realistic!). You may specify the details not included in any way that makes sense.

Write:

1. A clear Enterprise Statement for your database.

2. A Universal Relation with some sample data values.

3. At least ten Business Rules, modeled after those found in section 2-4 in your book.

Reference no: EM133217900

Questions Cloud

Discuss the gender specific issues : Discuss the gender specific issues that women suffer within society. Include examples in response from any jurisdiction of choice

Implement the insertion sort and merge sort : Implement the insertion sort and merge sort algorithms with any programming language you choose and run them with the same input number list

Changed automatically : How do I code this in excel/ vba so that when the user chooses values below 0.6 or above 0.61 the 0.5, and 1 are changed automatically.

What are the goals of a patient interview : What are the goals of a patient interview? Name and described each component of the Patient History (Chief Complaint, History of Present Illness, etc.)

Database system to keep track of information : Database system to keep track of information such as who has enrolled, what activities each teen has signed up for, and instructors and locations for activity

What is the underlying cause of psoriasis : Description - KM is a 38-year-old white woman with a 6-year history of psoriasis. What is the underlying cause of psoriasis

What type of algorithm would you use in that scenario : Describe the main idea how this algorithm is connected to the stochastic simulation algorithm and the deterministic ODE description

Explain debt capital to finance a small business growth : Explain the advantages and disadvantages of using equity capital and debt capital to finance a small business's growth.

Return the number of balanced vertices in a orientation : You want to come up with an orientation that maximizes the number of balanced vertices. Return the number of balanced vertices in a orientation that maximizes

User Account

All Pages