Reference no: EM132627925
Design the E-R Diagram for the following application. State any assumptions you might make. The diagram should contain all the required components (primary keys, cardinality constraints, etc.).
MCBikes Database
A requirement gathering process has provided the following description of a Massachusetts-based company in Boston (MCBikes), provider of self-service bicycle rentals. The company has various self-service hire/rental 'locations' throughout the city- users take and drop bicycles at locations. Each location has Internet enabled terminals for users to request a hire and to log the return of the bike. Some users are guests who will pay for a single hire by credit card (details retained until bike returned), whilst subscription users have a contract that allows them unlimited hires for a monthly fee. A user rents a bicycle from a location and may return the bike to a different location. Users may take bicycles for up to a week and guest users must pay for at least an hour. Each time a user takes a bicycle, the rental system logs it as a new hire.
Information stored on the bicycles for hire include: the bike reference number, model (they are all of the same make), date first in service, geo-position (they have a tracker fitted), last and current locations and service history.
The data stored on a hire includes the user's registration number, the bicycle reference number, the date and time the hire started, and the hire location.
There are two types of users: guest and subscription, both have an account with the company. The data stored on guest users includes their user number, their name (first and last name), home address, phone number, date of birth, and credit card number, and rental history.
The data stored on subscription users includes the user number, contract type, direct debit details, address, age, rental history (which may include dates, times, and location to location hires, bicycle reference number).
Data stored on each location is the street address, geo-location and assigned supervisor (who checks the location at intervals and inspects bikes for faults).
|
What is the cash flow to shareholders for zigs industries
: Net fixed assets were $19,759, current assets were $7,227, and current liabilities were $3,830. What is the cash flow to shareholders for 2015?
|
|
Full functional dependency and partial dependency
: For database management, discuss the difference between full functional dependency and partial dependency. Include an example
|
|
Identify how accounting information will be used
: Identify how accounting information will be used. The Philippine government will formulate national policies and formulate statistics for long-term development
|
|
What is the unit contribution for hohner
: What is the unit contribution for Hohner? What is Hohner's break-even point? What market share does Hohner need to break even?
|
|
Design the e-r diagram for the application
: State any assumptions you might make. The diagram should contain all the required components (primary keys, cardinality constraints, etc.).
|
|
What is the curse of dimensionality
: 1. Explain the role of a kernel function in instance-based learning?
|
|
What is the balance of Maduro capital account
: By mutual agreement, the assets are to be adjusted to their fair value of P 216,000 at June 30, 1998. What is the balance of Maduro capital account
|
|
How many marine bands must hohner sell to break even
: Determine How many units must Hohner sell to achieve the same profit (in terms of dollar amount) next year as it earned this year?
|
|
What size of multiplexers are needed
: [1] A digital computer has a common bus system for 16 registers of 32 bits each. The bus is constructed with multiplexers.
|