In this assignment, you are to create a database design for a software system that will...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
In this assignment, you are to create a database design for a software system that will be used to manage a marina. A marina is a place where boat owners can keep their boats "parked" in berths. Each size of a berth has a price which is calculated as 200 times the size of the berth (in meters) per month. For example, a berth that is 12m in size will be priced as 2400/month. For catamaran vessels the multiplication factor is 245 times the size of the berth. Boats are measured by their length and are always rounded up to the nearest meter. For example, a boat that is 11.2m will be recorded as a 12m boat. The marina that we will model has services such as: refueling, battery disposal, sewerage pump-out, lift out, waste oil disposal, and laundry. Each type of service has a standard price. When the boat is moored in the berth, the boat can be connected to shore power so that small appliances on the boat can be used without the need for the owner to run a generator. If the boat consumes more than 50kWh of electricity, the owner of the boat will be billed for the excess usage. Boat owners are provided invoices at the end of each month for all the services that they have received throughout the month which is due 10 days after the invoice is generated providing, they are in good credit standing. When the payment for the invoice has been received, the owner will be given a payment receipt. For owners who are not in good credit standing, then they must pay for the services in advance. Advance payments will result in an invoice and a payment receipt immediately. If an owner contacts the marina for a certain length of berth and that berth size is not available, the marina can put the owner on a wait list. Requests on the waitlist can be set to expire after a certain amount of time. A history of all boats who were using each berth must be kept so that it is possible to know which boat was in which berth at a specific point in time. The tables in your database must be in 3NF. You do not need to show the process of normalization or the 1NF or 2NF tables, just the final design. When you are finished with your design, generate the 'create tables' script from the MySQL Workbench too and make sure that you can execute the script on your database. What to Submit The MySQL workbench file containing the model. The model needs to have consistent naming and must include all keys and attributes. The SQL file that can be used to create the tables in your model. Layout of a Typical Marina Just for reference to give you an idea of some things that might be tracked. Western Boundary Waste Oil Tank EFTPOS Fuel Pump Rubbish Wellington Marine Centre Dockway Lowryay Yacht Club Coffee Cart MARINA ENTRANCE seaviewmarina Grading Rubric (20 points) Entities (6 points) Relationships (6 points) Table Creation Script (4 points) Normalized to 3NF (4 points) Entrance 2 MAP SHOWING LAYOUT AT SEAVIEW MARINA BERTH KEY 10m 12m 14m 16m 18m 20m 14m Cat Ramp Access Marina Office 18m Cat 24m Cat 26m Cat Tra Park Rubbish Per Fier Launching Ramp 10 Parking Public T Bus Route to Wellington *Lower Hutt LOCATION OF SEAVIEW MARINA WELLINGTON HARBOUR In this assignment, you are to create a database design for a software system that will be used to manage a marina. A marina is a place where boat owners can keep their boats "parked" in berths. Each size of a berth has a price which is calculated as 200 times the size of the berth (in meters) per month. For example, a berth that is 12m in size will be priced as 2400/month. For catamaran vessels the multiplication factor is 245 times the size of the berth. Boats are measured by their length and are always rounded up to the nearest meter. For example, a boat that is 11.2m will be recorded as a 12m boat. The marina that we will model has services such as: refueling, battery disposal, sewerage pump-out, lift out, waste oil disposal, and laundry. Each type of service has a standard price. When the boat is moored in the berth, the boat can be connected to shore power so that small appliances on the boat can be used without the need for the owner to run a generator. If the boat consumes more than 50kWh of electricity, the owner of the boat will be billed for the excess usage. Boat owners are provided invoices at the end of each month for all the services that they have received throughout the month which is due 10 days after the invoice is generated providing, they are in good credit standing. When the payment for the invoice has been received, the owner will be given a payment receipt. For owners who are not in good credit standing, then they must pay for the services in advance. Advance payments will result in an invoice and a payment receipt immediately. If an owner contacts the marina for a certain length of berth and that berth size is not available, the marina can put the owner on a wait list. Requests on the waitlist can be set to expire after a certain amount of time. A history of all boats who were using each berth must be kept so that it is possible to know which boat was in which berth at a specific point in time. The tables in your database must be in 3NF. You do not need to show the process of normalization or the 1NF or 2NF tables, just the final design. When you are finished with your design, generate the 'create tables' script from the MySQL Workbench too and make sure that you can execute the script on your database. What to Submit The MySQL workbench file containing the model. The model needs to have consistent naming and must include all keys and attributes. The SQL file that can be used to create the tables in your model. Layout of a Typical Marina Just for reference to give you an idea of some things that might be tracked. Western Boundary Waste Oil Tank EFTPOS Fuel Pump Rubbish Wellington Marine Centre Dockway Lowryay Yacht Club Coffee Cart MARINA ENTRANCE seaviewmarina Grading Rubric (20 points) Entities (6 points) Relationships (6 points) Table Creation Script (4 points) Normalized to 3NF (4 points) Entrance 2 MAP SHOWING LAYOUT AT SEAVIEW MARINA BERTH KEY 10m 12m 14m 16m 18m 20m 14m Cat Ramp Access Marina Office 18m Cat 24m Cat 26m Cat Tra Park Rubbish Per Fier Launching Ramp 10 Parking Public T Bus Route to Wellington *Lower Hutt LOCATION OF SEAVIEW MARINA WELLINGTON HARBOUR
Expert Answer:
Posted Date:
Students also viewed these databases questions
-
Teramycin Inc.'s perpetual inventory records indicate that $715,275 of merchandise should be on hand on January 31, 2008. The physical inventory indicates that $698,150 of merchandise is actually on...
-
Image transcription text Module 5 Discussion A' Instructions: This discussion will be completed in two parts, and will give you an opportunity to reect upon this week's content and to interact with...
-
Write a project management plan. we have a template and project description. we need to edit the template(table of contents) with our own ideas. CPSC 8820-01 Project Management Plan Your Unique...
-
Scranton Refrigeration Corporation began operations at the beginning of the current year. One of the companys products, a compressor, sells for $370 per unit. Information related to the current years...
-
Hyram Drant, a research analyst for the city fire department, suspects that old water pumps are more likely to fail. From the data in the accompanying table, construct a contingency table and check...
-
Why does an increase in NWC represent a cash outflow?
-
Lococo Manufacturing Inc. operates the Patio Furniture Division as a profit cen- ter. Operating data for this division for the year ended December 31, 2002, are as follows. In addition, Lococo...
-
Dollar-Value LIFO Retail You assembles the following information for Dillon Department Store, which computes its inventory under the dollar-value LIFO method. Increase in price level for year...
-
5. Suppose sin x = and 270 < x < 360. a. (5 pts) Use identities to find the exact value of sin b. (5 pts) Use identities to find the exact value of cos c. (5 pts) In what quadrant is the angle?...
-
Consider a particle of mass m that is bouncing vertically & elastically reflecting hard floor where **** V(Z) = { on a mgz + 7 > ZYO Z 0
-
Last month when Holiday Creations, Inc., sold 43,000 units, total sales were $172,000, total variable expenses were $142,760, and fixed expenses were $38,500. Required: 1. What is the company's...
-
On January 1, 2024, Jaewoo Industries had outstanding 680,000 common shares ($1 par) that originally sold for $20 per share, and 4,000 shares of 10% cumulative preferred stock ($100 par), convertible...
-
1.Two identical ping pong balls are rolling toward each other. Ball one is shot to the east at a speed of 1.40 m/s and ball two is shot to the west at 6.20 m/s. They do not hit head on but have a...
-
The following standards have been established for a raw material used to make product 084: Standard quantity of the material per unit of output Standard price of the material The following data...
-
Following are the issuances of stock transactions. 1. A corporation issued 8,000 shares of $20 par value common stock for $192,000 cash. 2. A corporation issued 4,000 shares of no-par common stock to...
-
Explain how statistical data can be used to improve healthcare delivery. Please provide your sources.
-
For the following exercises, write the polynomial function that models the given situation. Consider the same rectangle of the preceding problem. Squares of 2x by 2x units are cut out of each corner....
-
Polecat Corporation is considering beginning drilling operations in three separate fields. Polecat decides to analyze these fields using a 13% discount rate. The estimated cash flows for each field...
-
Define the following: asset retirement obligation retirement accretion promissory estoppel legally enforceable obligation obligating event
-
Define the following: impairment asset group traditional present value approach expected present value approach
Study smarter with the SolutionInn App