Phases of the database design process

Assignment Help Basic Computer Science
Reference no: EM13853077

Assignment:

The requirements collection and analysis phases of the database design process have provided the following data requirements for Big City Rentals, which rents out vehicles. Big City Rentals has several rental outlets. Each outlet has an outlet number, address, phone number, and fax number.

Each outlet has many vehicles for rent. The vehicle registration number (VRN) uniquely identifies each vehicle for rent and is used when renting a vehicle to a client. A brand new Outlet may not yet have any vehicles.

Clients may rent vehicles for various periods of time. Client data is entered into the database system when the client rents for the first time. Each individual rental agreement between a client and Big City Rentals is identified using a unique rental agreement number (RAN). Data listed on the rented vehicle include: vehicle registration number (VRN), model, make, year, and outlet number of vehicle.

The data listed on each rental agreement include the rental agreement number (RAN), the outlet number, the client number, client name, client address, client phone number, the date the client started the rental period, the date that ends the rental period, the daily rental rate, the vehicle registration number (VRN), model, make, vehicle year, mileage at start of rental period, and mileage at end of rental period. At the conclusion of each rental, a member of staff inspects the vehicle and enters any problems with the vehicle on a Check-in Report. A Check-in Report is always prepared regardless of whether there are any problems found. Check-in Report information on each vehicle is stored in the database system. Check-in Reports list the staff number of the staff that inspected the vehicle, date inspected, problem description, the vehicle registration number (VRN), make, model, vehicle year, and mileage at end of the rental period. Past Rental Agreements and Check-in reports are permanently saved in the database system.

The data stored on clients include the client number, name, address, and phone. The client number uniquely identifies each client and the data stored in the database system relate to all clients who have rented in the past and those currently renting. A client can
rent from any outlet.

Data stored on the staff include staff number, name, home address, home phone number, date of employment, outlet number, and salary.

REQUIRED: Create an ER diagram of Big City Rentals. Your diagram should provide all entities, relationships, relationship labels and arrows, multiplicity notation, keys (PKs and FKs), and non-key attributes. Each non-key attribute should appear in only one entity.

Reference no: EM13853077

Questions Cloud

Complete fair value allocation including goodwill allocation : What journal entries would be recorded on January 1, 2015 and what steps would you take to get there. As of January 1, 2015, Complete the fair value allocation including goodwill allocation & amortization.
Describes the advantages of using a diagnostic model. : Describes the advantages of using a diagnostic model.
Examine the assumptions and limitations of statistical study : Evaluate the article and critique the statistical analysis employed in the study. Would you have included more and/or different variables? Explain your answer. Examine the assumptions and limitations of the statistical study
Megatrend of demographics : Evaluate the megatrend of demographics in the IT field. Give your opinion as to why IT managers must understand this megatrend when selecting talent for organizational positions.
Phases of the database design process : The requirements collection and analysis phases of the database design process have provided the following data requirements for Big City Rentals, which rents out vehicles. Big City Rentals has several rental outlets. Each outlet has an outlet num..
Analyze changes in family relationships : This week, analyze changes in family relationships over the last 150 years. Consider the following aspects and their impact on adult careers and parenting: Variations in the types of families considered acceptable by society
Course is energy value chain : The course is Energy Value Chain. You are a consultant working for an advisory company that prepares concise reports for clients to "educate" senior managers in the respective clients' organizations about topics with which they are not familiar.
Start with an action-packed description of an experience : Start with an action-packed description of an experience that happened to you in the past several months. Maybe it happened this morning.
Calculate and compare the financial ratios : Calculate and compare the financial ratios listed further down this document for the fiscal year ending 2011 and prepare your comments about the two companies' performance based on your ratio calculations.

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  Performance of receiver-initiated load sharing algorithm

Predict the performance of receiver-initiated load sharing algorithm when entire system workload is generated at only a few nodes in the system instead of equally.

  Assess the key practices and improvement actions from the

q1. evaluate the key practices and improvement activities from the people capability maturity model and recommend the

  Information security management and framework choice

What are the major perspectives to consider in information security management and framework choice

  Explain company-s business intelligence products and service

Go to IBM.COM discover all company's business intelligence (BI) products and services Explain their process in minimum of half page to full page.

  Designing structured cyclic scheduler with fixed frame size

Executed according to structured cyclic scheduler with fixed frame size. We require to make three types of design decisions according to: i) Select suitable frame size based on constraints.

  Convert to mips the following expression

The subsequent problems deal with translating from C to MIPS. Assume that the variables f, g, h, i, and j are assigned to registers $s0, $s1, $s2, $s3, and $s4, respectively. Suppose that the base address of the arrays A and B are in registers $s6..

  Disaster recovery and business continuity policies

Disaster Recovery and Business Continuity Policies

  What are the pros and cons of sparklines versus

question 1 what are the pros and cons of sparklines vs. charts?question 2 do you prefer using the datasheet view or the

  Write a program that can be used to assign seats

Write a program that can be used to assign seats for a commcommercial airplane. The airplane has 13 rows, with 6 seats in each row. Rows 1 and 2 are first class, rows 3 to 7 are business class, and rows 8 to 13 are economy class

  Explain various kinds of storage devices

Explain what storage devices are, comprising the explanation of storage media. Write examples of at least three various kinds of storage devices.

  Determine decimal value on big-endian machine

A 32-bit word on the little-endian computer has decimal value of 261. Determine its decimal value on big-endian machine?

  A fuel economy study was carried out

A Fuel economy study was carried out for five models of cars. each car was driven 100 miles, and then the model of the car and the number of gallons used were placed in a line of the file Mileage.txt. Table 7.22 shows the data for the entries of t..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd