Question

[1] Please draw an ERD based on the following description. The requirements collection and analysis phase...

[1] Please draw an ERD based on the following description.

The requirements collection and analysis phase of the database design process has provided the following data requirements for a company called Reliable Rentals, which rents out vehicles (cars and vans).

The Company has various outlets (garage/offices) throughout Glasgow.

Each outlet has a number, address, phone number, fax number, and a manager who supervises the operation of the garage and offices at each site.

Each site is allocated a stock of vehicles for hire, however, individual vehicles may be moved between outlets, as required. Only the current location for each vehicle is stored. The registration number uniquely identifies each vehicle for hire and is used when hiring a vehicle to a client.

Clients may hire vehicles for various periods of time (minimum 1 day to a maximum 1 year). Each individual hire agreement between a client and the Company is uniquely identified using a hiring number. Information stored on the vehicles for hire includes: the vehicle registration number, model, make, engine size, capacity, current mileage, date MOT due, daily hire rate, and the current location (outlet) of each vehicle.

The data stored on a hire agreement includes the hire number, the client’s number, name, address, and phone number, date the client started the hire period, date the client wishes to terminate the hire period, the vehicle registration number, model and make, the mileage before and after the hire period. After each hire, a member of staff checks the vehicle and notes any fault(s). Fault report information on each vehicle is stored, which records the name of the member of staff responsible for the check, date checked, whether fault(s) were found (yes or no), the vehicle registration number, model, make and the current mileage.

The Company has two types of clients: personal and business. The data stored on personal clients include the client number, name (first and last name), home address, phone number, date of birth, and driving license number. The data stored on business clients include the client number, name of business, type of business, address, telephone, and fax numbers. The client number uniquely identifies each client and the information stored relates to all clients who have hired in the past and those currently hiring a vehicle.

Information is stored on the staff based at various outlets including staff number, name (first and last name), home address, home phone number, date of birth (DOB), sex, National Insurance Number (NIN), date joined the Company, job title, and salary. Each staff member is associated with a single outlet but may be moved to an alternative outlet as required, although only the current location for each member of staff is stored.

Homework Answers

Answer #1

The ER diagram of the given scenario is below. It consist of 4 entities connected via 4 relationship. Entity client has generalization into personal and business client. All attributes of entity client will be there in its sub entity (personal, business) plus some additional entities.

Each entity has certain set of attributes and primary key is mentioned as underlined attribute.

Cardinality is shown using crow's foot notation.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Draw a hi-fidelity E-R diagram for SQL Swampland RealEstate Swampland Real Estate is a small real...
Draw a hi-fidelity E-R diagram for SQL Swampland RealEstate Swampland Real Estate is a small real estate agency owned by Jimmy Goodeal. In fact, the agency is so small that Jimmy is the only agent in the company. He wants to have a database that keeps track of key information for his company. Of course, property information is very important. Jimmy wants to be able to store the address (street, city, state & zip code) for each property. He also...
draw the entity relationship model for the following data he system needs to record details of...
draw the entity relationship model for the following data he system needs to record details of all registered vehicles driven in the local government area. A vehicle is identified by a Vehicle Identification Number (VIN). Background reading on a VIN is available from several sites such as ​AutoCheck​. The government wishes to record the type of vehicle, such as motorbike, car, truck etc, the year the vehicle was manufactured and the model such as CX3, as vehicle attributes. Vehicles are...
Can you please give me an example of an EER modeling diagram for the following description:...
Can you please give me an example of an EER modeling diagram for the following description: Consider a database in which weekly schedule of instructors is stored. For each instructor, name, title (Dr., Prof., Ms., Mr… ) email address, office phone number, semester, the day of week, time slot (e.g. 8 to 9, or 10:30 to 11:30…), availability of the instructor (lecture or lab or office hours), the location that instructor is available/ busy (class room number, lab number, office...
Create an ERD for the Following: The H.I. Topi School of Business operates international business programs...
Create an ERD for the Following: The H.I. Topi School of Business operates international business programs in 10 locations throughout Europe. The school had its first class of 9,000 graduates in 1965. The school keeps track of each graduate’s student number, name when a student, country of birth, current country of citizenship, current name, current address, and the name of each major the student completed (each student has up to two majors). To maintain strong ties with its alumni, the...
Florida Now Real Estate (45 pts) Tanya Pierce, President and owner of Florida Now Real Estate...
Florida Now Real Estate (45 pts) Tanya Pierce, President and owner of Florida Now Real Estate is seeking your assistance in designing a database for her business. One of her employees has experience in developing and implementing Access-based systems, but has no experience in conceptual or logical data modeling. So, at this point Tanya only wants you to develop a conceptual data model for her system. You are to use our entity-data diagramming notation - Crows foot symbols. Tanya has...
Create an ERD based on the following Summit Sporting Goods scenario. Be sure to follow drawing...
Create an ERD based on the following Summit Sporting Goods scenario. Be sure to follow drawing conventions for readability and clarity. “I’m a manager of a sporting-goods wholesale company that operates worldwide to fill orders from retail sporting-goods stores. The stores are our customers (some of our people prefer to call them our clients). Right now we have 15 customers worldwide, but we’re trying to expand our customer base by about 10% each year starting this year. Our two biggest...
Requirements: Based on the following information, draw an E-R diagram and a set of relations in...
Requirements: Based on the following information, draw an E-R diagram and a set of relations in 3rd normal form. Please indicate any assumptions that you have made. Wally Los Gatos, owner of Wally’s Wonderful World of Wallcoverings, has hired you as a consultant to design a database management system for his chain of three stores that sell wallpaper and accessories. He would like to track sales, customers, and employees. After an initial meeting with Wally, you have developed a list...
Oracle Database Analysis and Design This project is to develop and implement an Oracle database. See...
Oracle Database Analysis and Design This project is to develop and implement an Oracle database. See the scenario of the Investment database. This simplified Investment Portfolio case study maintains information regarding clients that invest in stocks and mutual funds. Each client has a unique taxpayer identification number. A client may invest in stocks or mutual funds. A stock is uniquely identified by its ticker, which is symbol on the stock exchange. The name of issue for a stock is the...
Instructions: ​You must draw the ER Model for SpaceX Bank, save the ER Model as a...
Instructions: ​You must draw the ER Model for SpaceX Bank, save the ER Model as a png or jpeg, put your name on it and submit it on Blackboard before the due date. ​You can use ​any software​ you like to create this model. No emailed homework will be accepted no exception, and No late homework will be accepted no exceptions. Create the ER Model for ​SpaceX​ ​Bank ● Showalltheentities(regularentity,associativeentityorweakentity)with their attributes(key attribute, regular attribute or multi value attribute etc..)...
Description In this project you will practice what we have learned in class about Design, ER...
Description In this project you will practice what we have learned in class about Design, ER Diagrams, Relational Models, DDL, SQL, CRUD (Create, Update, Delete) operations, associated queries, and mock data population. The goal is to create a realistic professional database/development experience. This assignment will describe the requirements for the database as you might receive them. You will need to fill in the details as you work on it. You will find that your work may be iterative, and you...