Data Management

User Generated

jvyyvnzxhzv

Computer Science

Description

QUESTION 1,

Data Management Project: Logical Design(WEEK 3)

The Data Management Project for week 3 builds upon what you did for the Data Management Project in weeks 1 and 2 (ANSWERS YOU PROVIDED ARE ATTACHED). Create a logical data model of data management project showing the entities, relationships, primary keys, and foreign keys. Eliminate composite attributes, like student_name, by creating student_first_name and student_last_name. Create associative entities to resolve any many-to-many relationships between entities. Make sure each entity is in third normal form, meaning that each non-key attribute must depend on the primary key, the whole primary key, and only nothing but the primary key. Use the draw.io tool (https://www.draw.io/) to create your logical model.

Export your data model as a PDF, as shown in the Draw.io video tutorial. Submit the PDF .

YOUTUBE:

  • Video: Module 6 – Normalization of Data Tables (10:44 min.)
  • Video: Module 6 – Improving the Design (8:34 min.)

Question 2.

the data model attached (employee saving fund) . For that data model , copy and paste that data model graphic into a MS Word document. (You can copy the data model graphic by right-clicking on it. On PCs, the keyboard combination of ctrl-V is the shortcut command for pasting.) In your MS Word document, 1) identify the entity or entities that represent a supertype and the entities that are subtypes, 2) specify which attributes the subtypes inherit from the supertype(s), 3) specify which attributes are unique to each subtype.

you tube:

  • Video: Module 5 – Entity Supertypes and Subtypes (4:55 min.)
  • Video: Module 5 – Inheritance and the Specialization Hierarchy (2:14 min.)
  • Video: Module 5 – Selecting Primary Keys (7:29 min.)

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 PK Model Code Customer Car Car Model PK Reg_No Model_Name Millage model_desc Engine_Size Phone Daily_hire_rate date_Not_Due PK CustomerID Customer_First_Name Gender Email_Address Address Phone Booking Booking Status PK PK Bookingid Booking Status Code Date_From Status description Date_To Confirmation Payment
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hello, Check the two documents.Thank you for your time

DATA MANAGEMENT DATA MODEL
Student’s Name
Course Title
March 26, 2019

Data model

Questions

1) identify the entity or entities that represent a supertype and the entities that are
subtypes.
The table outl...


Anonymous
Just what I needed…Fantastic!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags