Tarleton State Identification of Appropriate Fields Containing Values Problems

Hello!

This is a word problem assignment. Why? Because most business problems are not laid out in a format that is applicable for databases and data capture. This is part art and part science. The trick is to understand certain patterns that are created. These should be outlined in a video and in notes! Also, there will be word problems as part of the midterm and the final.

The assignment itself is worth 50 points.

The assignment is due on February 17th.

The assignment has the following questions/requirements.

0. For 5 points, write an honor statement – this statement should be a short paragraph with items like how this is an original work, that cheating for this response did not occur, or that Nagy is not a sucker for trusting you. Tell me that you have honor and it is your work.

1. For the word problem, identify all values present. (5 points)
   1. This mean pulling all values from the paragraph!

2. For these values, identify fields, records, and tables for the values. (10 points)

1. 1. Start by identifying appropriate fields to contain the values
   2. Then, look at the related fields to identify records!
   3. Then, create the appropriate tables for these groups.

3. From the business rules in the case, identify appropriate links between tables (10 points)

1. 1. This is creating the PK/FK (Primary Key/Foreign Key) relationship between the tables.

4. Finally, draw the Entity Relationship Diagram (ERD) as outlined by the tables identified. Do not include the fields with the tables, as these should be identified above. (25 points)

1. 1. ERD may NOT be hand drawn; responses must use a program to draw the ERD.
      1. ERDPlus.com is a tool others have used in the past
      2. Personally, I use paint or power point

5. Finally, write the SQL statements that will create the tables and relationships as identified. These statements should have the fields as identified! Do not load the tables with the values identified…not here…(5 points)

The word problem:

Captain Jim Miller retired from the Air Force and joined a group of recreational pilots in the San Francisco area, the Mad Bay Bombers. The Mad Bay Bombers practice aerial acrobatics and attract members from as far away as Los Angeles and Sacramento. One day Jim offered to fly down to meet a group member in Los Angeles and made the return trip with four other passengers and Mad Bay Airlines was formed. The airline specializes in roller coaster air travel in California, focusing on trips under two hours. Currently, there are five small passenger planes that fly between San Francisco, San Jose, Sacramento, and Las Vegas. Flights are irregular, as the pilots are all Air Force retirees, but one of the fifty members can be always be convinced to make a Friday afternoon flight to Las Vegas and a Sunday evening flight returning to San Francisco. To get a flight scheduled, Jim sends out a message in a group chat to see if anyone wants to make a trip. He only sends out the message after he’s had interest from a group of two or more people for a specific trip. Trips are claimed first-come, first-served by the different pilots. Once claimed, the customers show up at the airport an hour early for a security clearance and a complementary Dramamine pill (it helps with motion sickness…once a passenger got sick…it wasn’t pretty). Then they make their flight.

Please follow the format below:

Question 1

<<<RESPONSES>>>

Double line ——————————————————————————————

——————————————————————————————————–

Question 2

<<<RESPONSES>>>

Double line ——————————————————————————————

——————————————————————————————————–

Question 3

<<<RESPONSES>>>

Double line ——————————————————————————————

——————————————————————————————————–

Question 4

<<<RESPONSES>>>

Double line ——————————————————————————————

——————————————————————————————————–

Question 5

<<<RESPONSES>>>

Double line ——————————————————————————————

——————————————————————————————————–