Reference no: EM1371018
Complete the following task. In each exercise, represent your answer in both DBDL and with a diagram. You may use any of the styles presented in this chapter for the diagram.
1. Design a database to produce the following reports. Do not use any surrogate keys in your design.
a. For each marina, list the marina number, name, address, city, state, and zip code.
b. For each boat owner, list the owner number, last name. first name, address, city, state, and zip code.
c. For each marina, list all the slips in the marina. For each slip, list the length of the slip; annual rental fee, name and type of the boat occupying the slip; and boat owner's number, last name, and first name.
d. For each service category, list the category number and description. In addition, for each service request in each category, list the marina number, slip number of the boat receiving the service, estimated hours for the service, hours already spent on the service, and next scheduled service date.
e. For each service request, list the marina number slip number, category description, description of the particular service, and a description of the current status of the service.
2. Expand the database design you created in Exercise 1 so that it will also support the following situation: A specific technician handles each service request. Along with all the details concerning a service request listed in Exercise 1, list the number, last name, and first name of the technician assigned to handle the request.
|
Venture capital funding
: Determine what are some of the sources companies can turn to for venture capital funding?
|
|
Question related to humanities
: How did the more dynamic and complex view of the universe affect the literature, art, and composition of the early 20th century?
|
|
Illustrate at what price will y shut down
: Profit max level of output. Quantity firm will minimize average total cost. Illustrate at what price will y shut down.
|
|
Examining enron''s business failure
: Compare and contrast the contributions of leadership, management, and organizational structures to the organizational failure.
|
|
Create database to produce reports using surrogate keys
: Complete following task. In each exercise, represent answer in both DBDL and with diagram. You may use any of styles for diagram. Create database to produce following reports. Do not use any surrogate keys in design.
|
|
Average and marginal costs
: Earlier this year the increasing price of tortillas resulted in major protests in Mexico City combined with a warning from Mexican central bank that this may fuel rising inflation.
|
|
Supply and demand - selling human kidneys
: What does the supply and demand for human kidneys look like and If a market in kidneys were legal, who would get them? How does a law prohibiting kidney sales affect the quantity
|
|
How far does the car move during that time
: A train 400m long is moving on a straight track with a speed of 84.30km/h. The engineer applies the brakes at the crossing and later the last car passes crossing with the speed of 17.7 km/h. suppose constant acceleration; conclude how long the tra..
|
|
Increase in the equilibrium price
: Web-tutoring - leftward shift of supply, an increase in the equilibrium price?
|