Create Entry relationship diagram (ERD)Data dictionaryClear handwriting please Easy Going Car Rental (EGCR) is a newly opened car rentalservice that is located in Barka. The manager Mr Nasser Mohammedis a technology oriented person. He doesn't want to run his businesson a paper based system. ECGR would like to solve theirproblems; they have heard something about databases but arenot really sure what it is all about.ECGR rents different types of cars including buses, sedan, four-wheelers, luxury cars and other types maybe added in the future.Each car has a unique plate number and each car has different color,model and the year it's made. Each car type has a different daily rateof rental.Apart from ECGR wanting to keep information about rental, theywould also like to keep a good record of their employees. Theywould like to have employee passport number, name, GSM andaddress.ECGR has multiple branches, every car rented from a specificbranch must be returned back to the same branch. ECGR would liketo record the details of the customer including customer civil ID,customer full name, Date of birth, gender, GSM and office number.• Each car belongs to a specific branch and when a car is rented itis important to keep information such as which car is to be rented,date rented and employee that is authorizing this rental.When a car is returned the date returned must be recorded, dependingon the date rented, date returned and rate an amount must be storedthat the customer must pay. MR Nasser would also like to have astatus showing whether the amount has been paid or not.You are a database developer intern (trainee) who knows MR Nasser,he has explained to you what his vision is and you have offered to helphim develop a database for ECGR. In return MR Nasser has agreed togive you free rental to you and your family for 6 months.Entity Relationship Diagram (ERD)Data dictionary

Answered: Create Entry relationship diagram (ERD)…

Engineering

Computer Engineering

Create Entry relationship diagram (ERD) Data dictionary Clear handwriting please

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Q: Explain the integration of data validation with data binding techniques.

A: The process of creating a link between an application's user interface (UI) elements (destination)…

Q: What do you understand by Data Redundancy?

Q: Explain Data Comparison program.

A: Data comparison: Data compare in SQL is a common tool for comparing and deploying the SQL server…

Q: Explain the benefits of data binding in the context of rapid prototyping and iterative development…

A: Data binding is a technique that connects user interface elements to data sources in software…

Q: latitude ER Diagram longitude description Convert to relation schema location last_visited

A: A rеlational schеma is a bluеprint for a rеlational databasе. It dеfinеs thе tablеs in thе databasе,…

Q: Explain the concept of data warehousing and how it differs from traditional database architectures.

A: Data warehousing refers to a specialized data storage and management system designed for the purpose…

Q: Define data modeling and explain its importance in the database development process.

A: Data modeling is a crucial aspect of database development serving as the blueprint for how data is…

Q: Explain the vocabulary used in data design, including entities, fields, common fields, records,…

A: Introduction: All of these names are synonymous with relational databases. Data is stored in…

Q: Define class name? Define attributes name and color

A: Class name The class name is used as the name for the class. It is also used as the name for the…

Q: Describe the concept of data warehousing and how it differs from traditional database systems.

A: Data warehousing is a technology utilized for data management and analytics.Its purpose is to…

Q: Explain how data binding is utilized in database systems to connect UI elements with data sources…

A: The process of creating a connection or linkage between the data in an application and the user…

Q: Describe the role of data dictionaries in facilitating the integration of disparate data sources

A: Data dictionaries are metadata components in database management, providing detailed information…

Q: The Pizza Ordering System allows the user of a web browser to order pizza for home delivery. To…

Q: Please explain how and why database design is crucial in an educational setting.

A: Introduction: Database design is essentially the process of arranging a vast quantity of data in a…

Q: A notation for describing the form and structure of data, data description language is used to make…

A: Answers:- Yes, that is correct. A data description language (DDL) is a syntax or notation used to…

Q: Database as a service for your library: what else should be considered?

A: The answer is given below step.

Question

Create Entry relationship diagram (ERD) Data dictionary Clear handwriting please

Easy Going Car Rental (EGCR) is a newly opened car rental
service that is located in Barka. The manager Mr Nasser Mohammed
is a technology oriented person. He doesn't want to run his business
on a paper based system. ECGR would like to solve their
problems; they have heard something about databases but are
not really sure what it is all about.
ECGR rents different types of cars including buses, sedan, four-
wheelers, luxury cars and other types maybe added in the future.
Each car has a unique plate number and each car has different color,
model and the year it's made. Each car type has a different daily rate
of rental.
Apart from ECGR wanting to keep information about rental, they
would also like to keep a good record of their employees. They
would like to have employee passport number, name, GSM and
address.
ECGR has multiple branches, every car rented from a specific
branch must be returned back to the same branch. ECGR would like
to record the details of the customer including customer civil ID,
customer full name, Date of birth, gender, GSM and office number.
• Each car belongs to a specific branch and when a car is rented it
is important to keep information such as which car is to be rented,
date rented and employee that is authorizing this rental.
When a car is returned the date returned must be recorded, depending
on the date rented, date returned and rate an amount must be stored
that the customer must pay. MR Nasser would also like to have a
status showing whether the amount has been paid or not.
You are a database developer intern (trainee) who knows MR Nasser,
he has explained to you what his vision is and you have offered to help
him develop a database for ECGR. In return MR Nasser has agreed to
give you free rental to you and your family for 6 months.
Entity Relationship Diagram (ERD)
Data dictionary

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

How can data dictionary tools and software streamline the process of creating and managing data dictionary entries?
Design databases only contain data about the spatial data of the design. True False
Explain the concept of data binding in the context of cross-platform mobile app development and its role in code reusability.
Database Design the database following an ER model- The ER should contain all necessary information such as entities, attributes, relationships, cardinalities etc. for this example (as shown in the picture) and do changes if necessary
What makes a repository different from a data dictionary?
Question 4 Ordinal data is a sub-part of the numerical data category within the data taxonomy. True False
What key information should be included in a typical data dictionary entry for a database table?
Explain the concept of data warehousing and its significance in modern database development.
Please explain how and why database design is essential in an educational setting.
Distinguish between a data attribute and a data item in this discussion.
T. Relational Model Instructions This assignment will show that you understand how columns should be separated between tables in a properly structured relational database. Your objective: Imagine you need to design a database that tracks members, type of membership, and exercise routines for each member. • Build a relational database model with multiple tables • Use your imagination and feel free to create the tables with as many columns as you would like. • Highest points will be awarded for completeness AND correctness. Submit as an Excel workbook or image.