1. Cruise Business Case: Part 1
The specialty cruise has a pirate theme and goes on fun missions. Cruise members become part of the crew.
Use the following business rules for the cruise database:
- Each employee (cruise members and captain) have unique IDs.
- There are two types of employees: crew and captain.
- You cannot be a crew member and a captain.
- Only captains have a parrot
- Each ship has at least 40 crew members
- Each mission has a unique mission number with one or more ships
- Provide all appropriate connectors.
2. Cruise Business Case: Part 2
The specialty cruise has a pirate theme and goes on fun missions. Cruise members become part of the crew.
For this question, use the following business rules:
- Each employee (cruise members and captain) have unique IDs.
- Only a captain has a parrot which can go to another captain.
- Only crew members can have dependents.
- There are many crew members on a ship.
- Each mission has a unique mission number with one or more ships.
In the questions below, select the best primary key(s) for each table.
3. Veterinarian Office Case: Part 1
A veterinarian office needs your help. They need to keep track of the owner and pet information. They also need to keep track of the appointments and the treatments for each pet.
For this question, use the following business rules:
- Each owner and pet have unique id’s.
- Each appointment has a unique id.
- There can be more than one treatment per appointment. Therefore, you need the Treatment_Appt table.
In the questions below, select the best primary key(s) for each table.
4. Veterinarian Office Case: Part 2
The veterinarian office needs to create a database to keep track of owner and pet information. They also need to track appointments and treatments for each pet.
Use the following business rules for the veterinarian database:
- Each owner, pet and appointment have unique IDs.
- There can be more than one treatment per appointment. Therefore, you need the Treatment_Appt table.
- What are the relationships between the tables? Select the appropriate connectors.
5. Travel Company Case
A travel company needs to keep track of their clients, trips and guides. They are setting up a database to replace their manual system.
For this question, use the following business rules:
- Each client, trip and guide have unique id’s.
- Each client can participate in many trips.
- There can be more than one guide per trip.
In the questions below, select the best primary key(s) for each table.
