QUESTION 1. the data model for child care center ( attached below) , copy and paste that data model graphic into paper using MS Word. In the MS Word document, list the following:all the entitiesall the attributes in each entitythe primary key for each entityall the foreign keysall the relationship cardinalities between entities (e.g., a professor can teach one to many classes; an individual class is taught by one and only one professor)for each relationship between entities, specify the name of the attribute in one entity that will be used to match to an attribute in a related entity, including the specific attribute name in the second entity that is used for the matching. For instance, in a school data model: “The Student_ID attribute in the Registered_Class entity is used to match to the Student_ID attribute in the Enrolled_Student entity.”Resources:YOUTUBETextbook: Module 3 – The Relational Data ModelVideo: Module 3 – Relational Database Tables and Their Characteristics (3:13 min.)Video: Module 3 – Relational Database Keys (1:48 min.)PowerPoint: Module 3 Review charts Textbook: Module 4 – Entity Relationship (ER) ModelingVideo: Module 4 – Entity Relationship Diagrams: Part I – Entities and Attributes (3:46 min.)Video: Module 4 – Entity Relationship Diagrams: Part II Identifiers (1:19 min.)Video: Module 4 – Entity Relationship Diagrams: Part III Relationships (3:54 min.)Video: Module 4 – Entity Relationship Diagrams: Part IV Relationship Degrees (2:13 min.)Video: Module 4 – Entity Relationship Diagrams: Part V Associative Entities (1:19 min.)PowerPoint: Module 4 Review chartsQuestion 2.Week 2 – Data Management Project: Conceptual DesignThe Data Management Project for Week 2 builds upon what you did for the Data Management Project in Week 1 (Answer you provided to me last week is attached for you to look on below). Create a conceptual data model of data management project showing the entities and relationships. Use the Draw.io tool to create your conceptual model. Export the data model as a PDF and save it on your PC, as shown in the Draw.io video tutorial. Submit the PDF to me.Resources:YouTube Video: Draw.io video tutorialNote: The Draw.io video tutorial shows you how to resolve many-to-many relationships in your entity-relationship diagram. You will need to do that in subsequent weeks, but not for this week’s assignment. For this week’s assignment, create the entities, relationships, primary keys, and attributes.
child_care_centers_pic.png
data_management_project_week1.docx
Unformatted Attachment Preview
Running head: CAR RENTAL MYSQL DATABASE
1
Car Rental MySQL Database
March 17, 2019
Overview
This paper entails all about a data management project. In this paper we are discussing
every aspect of database system among them the initial planning phase of the database project, the
CAR RENTAL MYSQL DATABASE
2
problem statement-where we outline how the problem/the project idea would be solved, the
constraints, the objective, the project scope and boundaries among other aspects of the database
design. In this case, we outline an MYSQL database project which is all about a vehicle rental
system. This is a management system which aims at ensuring that the vehicle rental system is
working as expected. It ensures that every record within the premise is recorded and the necessary
calculation about the rental cost well retained.
Problem Statement
Many people want to experience a driving experience with or without having to own a
vehicle. In most cases, people who don’t own any vehicle on their own find it difficulty accessing
vehicle there can drive for their own needs at their own free time. This MySQL database project
aims to ensure that it provides a platform where any individual can be able to register and access
a vehicle of his/her choice temporarily. This will enable them to perform their task with ease. In
specific the project will help solve the following problems;
i.
Enable car owner, or an agent leases his/her car temporarily for a profit.
ii.
Enable an individual to rent a vehicle of his choice for temporary usage.
iii.
Provide a wide choice of vehicle make and model to choose from.
iv.
Provide a flexible timeline for the car lease and rent – This enables each person to work
according to his time.
v.
Ease the management task when it comes to processing of the car rental services.
The Database Project Constraint
The success of this project implementation will be made possible if there is adequate project
related resources such as time, the budget and the project scope. It is through sticking within the
CAR RENTAL MYSQL DATABASE
3
project scope that we can be able to complete the project within the outline project timeline and
budget. At this level of project development, we can online outline the project constraint. There is
much we can expound about them, (Rouse, 2015). They are as follow;
The project scope – This defines what the project development team would be working on
i.
and what they would not work as outlined below.
The project timeline – This is the project allocated time, everything we would work on, on
ii.
this project would be guided by the time allocated by the project client.
iii.
Budget – This includes the resource that would determine the extent of the project
development.
iv.
Other constraints include human resources such as availability of the right project team
members and others not outlined here.
The Project Objectives
The specific aims of this car rental database project include; –
i.
To ease the process of car rental services by ensuring that the customers can access the
vehicles of their choice at ease.
ii.
To provide a platform where the car owners/agents would be able to outline their services
and products, and also ensure that customer can view and select from those services.
iii.
To ensure that it is easier to calculate the cost and the payment depending on the vehicle
rental period.
The Project Scope
This car rental MYSQL database project covers everything related to the implementation of a
complete database project. This is from the cost calculation, user’s registration and the project
CAR RENTAL MYSQL DATABASE
4
entities among others key elements of the project, (Moustafaev, 2014). The following outline some
of the key areas that we are going to focus on this project.
i.
Car rental – In this we are going to focus on the key areas about the car rental services as
it applies to this project.
ii.
System development – This entails theoretical concepts on how this car rental system
would be implemented using a MySQL database.
The project does not entail a real implementation of the actual car rental services.
The project scope entails the project boundary wherein simple terms, we are not going to
include the actual car names, customer or any representation of the similar system. The project
does not cover the actual car cost and other real aspects.
.
References
Moustafaev, J. (2014). Project Scope Management: A Practical Guide to Requirements for
Engineering, Product, Construction, IT and Enterprise Projects. CRC Press.
Rouse,
M.
(2015,
3
1).
Retrieved
from
https://whatis.techtarget.com/definition/constraint-project-constraint
techtarget.com:
CAR RENTAL MYSQL DATABASE
5
…
Our essay writing service fulfills every request with the highest level of urgency.
attachment
