User:Rafat ahmad ali
From Wikipedia, the free encyclopedia
UNIVERSITI UTARA MALAYSIA COLLEGE OF ARTS AND SCIENCES
Advance Database Design (TID5043)
MayFlower Malaysian Company
Prepared to:
Dr. Faudziah Ahmad
Prepared by:
Ra’fat Ahmad Ali Al-msie’deen.
Matric No: 800339
Table of Content :
CONTENT PAGE Table of Content. 1- 2 1. Company Profile. 3 2. about the company. 4 3. Background of Company. 5 4. Problems in Company. 6 5. Objectives of the System. 7 6. Company Mayflower Structure. 8 7. Company Database system. 9 8. Conceptual Database Design. 10
8.1. System tables.
10-12
8.2 Tables in Microsoft Access.
13-16
8.3 Database Concept.
17
8.4 Main Entity and Attribute of the Company:
18-19
8.5 Relation Diagram.
20
8.6 Entity Relationship (ER) Diagram.
21
8.7 The Entity Relationship Diagram Specification.
22-24
8.8 Company Class Diagram.
25 9. Logical Database Design. 26
9.1 Logical Database Design Steps.
26-27
9.2 Mayflower Logical Database (Create Tables).
28-32 10. Physical Database Design. 33
10.1 Physical Database Design Steps.
33-34 11. Comparison of Logical and Physical Database Design. 35
1. Company Profile:
Mayflower Car Rental (MCR) is the pioneer car Rental Company in Malaysia catering to multi-national & public listed companies, leisure customers and overseas wholesale agents. It also offers Chauffeur Service to tourists and business customers and has successfully handled major events like 16 th Commonwealth Games Kuala Lumpur 1998, APEC Conference Kuala Lumpur 1998 & 1999, NAM Summit 2003, OIC Summit 2003.
Being a strong supporting component of the inbound business, it has enabled Mayflower to offer more competitive self-drive products in the inbound market to better cater to the diverse needs of our customers worldwide. As such, MCR have been able to help developed self-drive holiday concept in Malaysia and attract more visitors to this country. Not only is MCR a contributor to the Malaysian travel industry, through its growth and innovation, it is also a major player in the Malaysian car rental industry.
Mayflower car Rental Company established to help people to renting car, chosen the branch, and the car models from the web site, any customer can use the web site to query about the services that provide by the company, and this very important and nice idea development by the company to provide perfect help to her customers.
Company Mission:
- to create & deliver travel experiences for our customers by anticipating, meeting & exceeding
their expectations.
- to add value by continuously providing reliable quality services & products to our customers. - to deliver profitable growth to enhance shareholders’ value.
Company Vision:
- to develop the method of travel in Malaysia and to became very easy. - to be recognized as the most respected and preferred partner in the travel industry. - to provide car rental services in any place in Malaysia 2. about the company:
Mayflower Car Rental (MCR) is the pioneer car Rental Company in Malaysia catering to multi-national & public listed companies, leisure customers and overseas wholesale agents. It also offers Chauffeur Service to tourists and business customers and have successfully handled major events like 16 th Commonwealth Games Kuala Lumpur 1998, APEC Conference Kuala Lumpur 1998 & 1999, NAM Summit 2003, OIC Summit 2003, Japan Super GT3 Championship Malaysia 2001, 2002, 2004 to 2006, Formula 1 (from 1999 to 2006) and A1 Team Malaysia 2005.
It has a fleet size of over 1000 vehicles with capacity ranging from economy class of 1,300 cc to luxury class of 3,000 cc. spread over a nationwide network of offices in all major cities and at major airport locations offering a 24-hour Emergency Assistance Line for its customers. Upon request, vehicles can be fitted with “Drive-Right” monitors to track drivers' performance. For the discerning customers, its vehicles can also be equipped with TM Automatic Vehicle Location System (TMAVLS) to facilitate tracking and reporting purpose to enhance customers' safety and Security.
Being a strong supporting component of the inbound business, it has enabled Mayflower to offer more competitive self-drive products in the inbound market to better cater to the diverse needs of our customers worldwide. As such, MCR have been able to help developed self-drive holiday concept in Malaysia and attract more visitors to this country. Not only is MCR a contributor to the Malaysian travel industry, through its growth and innovation, it is also a major player in the Malaysian car Rental industry. The company Chauffeur Services specializes in airport transfers, inter-office transfers and outstation services. Mayflower Chauffeur Services are available nationwide on an hourly, daily, Weekly and monthly service. The commitment is to maintain the highest standard of safety for our customers at all times. Our chauffeurs are well trained in safe defensive driving and retrain on annual basis where They are updated on the latest safe driving practices.
Mayflower has over 50 coaches and tour vehicles of varying size and model. This represents one of the largest fleet of tourist vehicles in the country for ground transportation. Together with our network of suppliers, we are able to increase our capacity several times over. We have the experience and expertise in handling large groups namely Tenaga National for the APEC Summit in Kuala Lumpur – 60 coaches, American Express meet in Kuala Lumpur – 30 coaches and more recently an Amway India Conference in Kuala Lumpur involving approximately 1,000 passengers.
Investment in coach and tour vehicles averaged close to RM1 million per annum for the last nine years, this despite the difficult economic environment in 1997 and 1998. Mayflower will continue to pursue this level of investment in our fleet in the coming years. In general, it is a company policy to replace all coaches on every five to six years; tour vans every three to four years and tour cars every two to three years.
3. Background of Company:
this project talk about the mayflower Malaysian company ,these company provide many services to the customer ,the company can provides car for the customer from many branches in the Malaysia ,and many models of car and can change the place to receive the car ,to save effort on the customers. Therefore the company is the first in Malaysia in this domain (car rental) .and the company have a lot of customers because it is provide good services and nice relation. The company has the web site the customer can use it to see the all information about the company, such as: company branches, car models, the mission and vision, and another services, and you can see the structure of the company from the website.
Figure-1: company website
4. Problems in Company:
this project talking about mayflower company for car rental in Malaysia, the company providing many services to customers and where the cars can provide the customer's from the branch of the company, mayflower company has many branches in Malaysia and is the headquarters of the company in the capital Kuala Lumpur and these branches in all the country, where The customer
Hires from the branch that near him.
The company owns the website, where the visitor can visit this website and make query about services that the company provide it, like the company branches , and the kinds of cars and models in this company, and another services that could be provided to the customer, but there are some problems , such as:
1. That the company did not identify the cost of renting a car at one o'clock or period of
time Such as: day, month, week, 12 hours….etc
2. The company did not identify the method to pay the cost of renting.
3. What are the options that the company can provide to the car such as children seat...etc
This does not mean that these problems can not be solved, but can be resolved through the good design of databases .in the design quality of databases must follow several of the most important things: requirements collection to study all aspects of the project, after the analysis begins work in databases design, where there are three steps: conceptual database, logical database, and Physical database design.
these problems(cost, how pay the cost, what is the car options), the company must solve them to get the perfect website design to provide all specifications about the car rental process, and the customer know all things about the car models and options before he/she start rent the car.
Some people he /she go to the branch to renting the car without any information, so may be doesn't found the car that he/she need to renting it. Therefore the website solve many problems and save effort on customer or the staff they work in the company.
the company website have many tables in my project like :branch ,staff , customer , car model's , car rental, car specification. And each table has many attributes, such as: car specification Tables have the model's-id, car-color, car-door, branch-id, and other tables.
In my opinion after implementation and add the renting cost, pay method, and car options. All of these problem can solve, to provide better service to the customer and more friendlily to the user, the traditional method to make the report is very bad and can make the report by the System now very easy and quickly.
5. Objectives of the System:
Mayflower car Rental Company established to help people to renting car, chosen the branch, and the car models from the web site, any customer can use the web site to query about the services that provide by the company, and this very important and nice idea development by the company to provide perfect help to her customers.
Main objectives:
1. Customer can do query about the services that provide by the company in this domain
(Car rental) from the website.
2. Customer can do query about the cost of renting, the method to pay the cost, and the
possible car options...etc
3. Company provide easy method to connection with customer through the website at any
time that customer need to do query about the company services.
4. It saves effort and cost to both customer and staff.
Figure-2: Mayflower Services 6. Company Mayflower Structure:
Figure-3: Mayflower Structure
In this diagram I make abstract about the company structure, the mayflower company for cars rental have the main office it is include the IT department and many staff, and the company have many branches around the Malaysia it is provide the services for customer. So every branch has many cars models and customer just chose one of this cars and continua the other operation to rent the car.
The company has a support to provide the new models of cars and any planning to make the company in the top. The company have special IT department to make a good computer system to the company, and good interface, customer can make query about the service from the internet. 7. Company Database system:
Figure -4: stage of the database system development lifecycle in company.
For small database system like Mayflower Company, with a big number of users, the lifecycle need not be very complex. The company has many table and relationship between these tables. Customer can rent the car at any time everywhere be connect the company quickly and easy in the airport, any places in Malaysia.
8. Conceptual Database Design:
8.1. System tables (after Normalization):
1. Branch table: Company has many branches such as:
Branch -ID Branch-name E-mail Address
KKKP 0596 KUALA LUMPUR HEADQUARTERS mcr-kl@mayflower.com.my Mayflower Building ,18, Jalan Segambut Pusat, 51200 Kuala Lumpur
KKKP 0782 PENANG mcr-pen@mayflower.com.my No. 48, Jalan Rangoon, 10400 Penang.
KKKP 1570 LANGKAWI mcr-lgk@mayflower.com.my No. 9, Pusat Mas, Kampung Pokok Asam, Jalan Kelibang 07000 Kuah, Langkawi, Kedah.
KKKP 2334 Kota Kinabalu mcr-kk@mayflower.com.my Unit No: D3 - 3A, 3rd Floor, Block D, Plaza Tanjung Aru, Jalan Mat Salleh, 88150 Kota Kinabalu, Sabah
KKKP 2842 JOHOR BAHRU mcr-jhb@mayflower.com.my ( Singapore – Johor Bahru Taxi Terminal), Level 2A, Plaza Seni, Jalan Trus, 80100 Johor Bahru
Main entity: Branch. Main attributes: Branch -ID, Branch-name, E-mail, Address.
2. Car Models table: company has many car models such as:
Model's-ID Model's Name Color Branch-ID
VG27.927
Nissan Serena Comfort 2.0 Red KKKP 0782
VR56.645
Toyota Unser 1.8 Blue KKKP 0596
AS33.456 Proton Wira 1.5 Black KKKP 1570
CS66.894 Hyundai Sonata 2.0
White KKKP 2842
Main entity: Car Models. Main attributes: Model's-ID, Model's Name, Color, Branch-ID.
3. Customer table: every customer renting the car has much information:
Cus-ID Cus-Name Passport-No Cus-Address Rent-Date Model's-ID Branch -ID
VC12 Ra’fat Ahmad J 555732 Santok-Kedah. 12-3-2008 VR56.645 KKKP 2842
DF22 Rami Ali M 435564 51200 Kuala Lumpur 16-3-2008 SC66.894 KKKP 0782
HJ99 Mohamad Nors S 435095 Langkawi, Kedah. 10-3-2008 AS33.456 KKKP 0596
Main entity: Customer. Main attributes: Cus-ID, Cus-Name, Passport-No, Cus-Address, Rent-Date, Model's-ID,
Branch -ID.
4. Staff table: every branch has a staff working in the company:
St-ID
St-Fname St-Lname Position Sex DOB Branch -ID
DF12 Ali Fadee Manager M 1-12-86 KKKP 0782
SL41 Ahmad Nors Assistant F 13-1-77 KKKP 1570
5. Car Renting table: these is table is describe the car renting process:
Cus-ID Branch -ID St-ID Period of Renting Date of Car Renting
Model's-ID
AS94 KKKP 2334 SL41
One Day
23-2-2008 VR56.645
DF22 KKKP 1570 DF34 Five hours 12-3-2008 SC66.894
VC12 KKKP 0782 DF12 Two days 21-1-2008 AS33.456
HJ99 KKKP 2842 TY88 One month 23-2-2008 SF88.999
6. Car Specifications: Car rent minutiae before the customer renting the car he/she is
Looking to the guide to see all specification about the car and minutiae:
Model's-ID
Capacity Door Car-Steering Windows Cost / Hour Branch -ID
VC12 1995cc Engine 4-door Power steering Power windows 40RM KKKP 2842
DF22 1584cc Engine 2-door Auto-steering Power windows
75RM
KKKP 1570
HJ99 1498cc Engine 4-door Power steering Power windows
65RM
KKKP 0782 8.2 Tables in Microsoft Access.
1. Company Database :
2. Branch Table:
3. Customer Table:
4. Staff Table:
5. Car Models Table:
6. Car Renting Table:
7. Car Specifications Table:
Now all tables is create in Microsoft access 2003,and can connect these database with any program language can deal with Microsoft access ,and can create the tables with another software like SQL(Oracle 10g),Microsoft SQL Server 2008,and any software support SQL.
Figure -4: create staff table using SQL commands.. 8.3 Database Concept:
Definition: A database is an application that manages data and allows fast storage and retrieval of that data. There are different types of database but the most popular is a relational database that stores data in tables where each row in the table holds the same sort of information. In the early 1970s, Ted Coded, an IBM researcher devised 12 laws of normalization. These apply to how the data is stored and relations between different tables.
Database Management System (DBMS): Software that controls the organization, storage, retrieval, security and integrity of data in a database.
Data Definition Language (DDL): Used by the DBA and database designers to specify the conceptual schema of a database. In many DBMSs, the DDL is also used to define internal and external schemas (views).
Data manipulation language (DML):A language that provides a set of operations to support the basic data manipulation operations on the data hled in the database.
Database models: Database models are a conceptual view of a database (view the database):
- Relational database model - Object-oriented database model
ER Model Concepts:
Entities: are specific objects or things in the mini-world that are represented in the database.
For example the BRANCH, STAFF, CUSTOMER ….etc.
Attributes: are properties used to describe an entity. For example an STAFF entity may have
an Fname, Lname, position……etc.
relationship: relates two or more distinct entities with a specific meaning. For example,
STAFF Ahmad Norse works on the BRANCH LANGKAWI……etc
8.4 Main Entity and Attribute of the Company:
1. Branch:
2. Car models:
3. Customer:
4. Staff:
5. Car Renting:
6. Car Rent Specifications:
8.5 Relation Diagram:
this is simple diagram show the main entity and the primary key of each entity and explain the relationship between the entity, the Branch entity have primary key is Branch-ID, and have main relation with the Customer , Staff , Car Renting ,and the Car Models. The Car Models have relation with the Car Specification.
In this diagram explain the main relations between the entities .and it is very important to any database system because it make abstract about the company database system, and another steps it is dependence on this step, and it is the first step to make the entity relationship diagram, so I am very carefully when I draw this diagram because it is very important.
8.6 Entity Relationship (ER) Diagram:
Main (ER) Diagram:
The Entity Relationship Diagram it is show: main entities, attributes, and the relationship, and the primary key of each entity. this diagram explain the relationships between the entities, each entity have primary key ,and have main relation with the other entities. Such as: the Branch entity has relation with the Customer, and has Branch-ID as a primary key. And have another Attribute such as: Branch-Name, E-mail, and address. 8.7 The Entity Relationship Diagram Specification:
1. Branch – Staff :
2. Branch – Customer :
3. Branch – Car Renting :
4. Branch – Car Models :
5. Car Models – Car Specifications:
all these components include the main Entity Relationship Diagram but I am study each parts alone, to increase understanding of the company Database system , I am taken each part alone . such as: the Branch - Staff , from this part I can determine all attributes of Branch and Staff and the relationship between two entities. these way increase the understanding of the system and like this , I take Branch - Customer alone and studies the relationship and attributes can called this way the sub Entity Relationship Diagram, and finally I collect the Subsystem to make the main Entity Relationship Diagram.
8.8 Company Class Diagram:
9. Logical Database Design:
9.1 Logical Database Design Steps:
Two stages:
- Building and validating local logical model: The local model represents different (or individual) user views what payroll sees vs. what the accounting sees? - Building and validating global logical model: The global model represents ALL users Views what will be the requirements of all departments combined?
Stage 1: Local logical model: 1.1. Remove features not compatible with the relational model: Objective: Refine the local conceptual data model to remove undesirable/unsupported features to
map to local logical model.
1.2. Derive relations for local logical model: Objective: derive tables to represent entities, relationships and attributes defined in the user
view.
1.3. Validate relations using normalization: Objective: Check that all information (entity, relationship, attribute) required by the transaction is provided by the model by documenting a verbal description of the transaction. and Represent the pathway taken by the transaction diagrammatically on the ERD. 1.4. Validate relations against user transactions: Objective: To ensure that the local logical Data model supports the transactions required by the User view). 1.5. Review local logical data model with the user: Objective: To ensure that the local logical Data model is a true representation of the user’s view.
Stage 2: Build and validate global data models:
2.1. Merge local logical data models into global model:
Objective: Merge local logical data Models into global model some typical tasks.
2.2. Validate global logical data model:
Objective: Validate the global logical data model Using normalization and against the required
transactions.
2.3. Check for future growth.
Objective: To determine whether there any significant changes likely in the foreseeable future and to assess whether the global logical data Model can accommodate these changes?
2.4. Review global logical data model with the users:
Objective: To ensure that the global Logical data model is a true representation of the enterprises.
9.2 Mayflower Logical Database (Create Tables):
1. Branch Table:
Branch -ID Branch-Name E-mail Address
Number (7) Varchar2 (12) Varchar2 (15)
Varchar2 (18)
Create table Branch (
Branch-ID Number (7),
Branch-Name Varchar2 (12),
E-mail Varchar2 (15),
Address Varchar2 (18),
Primary key (Branch-ID)
) ;
2. Car models table:
Model's-ID Model's Name Color Branch-ID
Number(8)
Varchar2 (12) Varchar2 (8) Number (7)
Create table Car models (
Model’s-ID Number (8),
Model's Name Varchar2 (12),
Color Varchar2 (8),
Branch-ID Varchar2 (7),
Primary key (Model’s-ID),
Foreign key (Branch-ID) references Branch
) ;
3. Customer table:
Cus-ID Cus-Name Passport. No Cus-address Rent-Date
Model's-ID Branch -ID
Number(8) Varchar2 (15) Number (10) Varchar2 (17) Date Number (8)
Number (7)
Create table Customer (
Cus-ID Number (8),
Cus-Name Varchar2 (15),
Passport. No Number (10),
Cus-address Varchar2 (17),
Rent-Date Date,
Model’s-ID Number (8),
Branch-ID Number (7),
Primary key (Cus-ID),
Foreign key (Model's-ID) references Car Models,
Foreign key (Branch-ID) references Branch,
) ;
4. Staff table:
St-ID
St-Fname St-Lname Position Sex DOB Branch -ID
Number(9) Varchar2 (10) Varchar2 (11) Varchar2 (12) Varchar2 (2) Date Number (7)
Create table Staff (
St-ID Number (9),
St-Fname Varchar2 (10),
St-Lname Varchar2 (11),
Position Varchar2 (12),
Sex Varchar2 (2),
DOB Date,
Branch-ID Number (7),
Primary key (St-ID),
Foreign key (Model's-ID) references Car Models,
) ;
5. Car Renting table:
Cus-ID Branch -ID St-ID Date of Car Renting Period of Renting Model's-ID
Number (8)
Number (7)
Number (9) Date
Varchar2 (19) Number (8)
Create table Car Renting (
Cus-ID Number (8),
Branch-ID Number (7),
St-ID Number (9),
Date of Car Renting Date,
Period of Renting Varchar2 (19),
Model's-ID Number (8),
Primary key (Cus-ID, Branch-ID, St-ID),
Foreign key (Model's-ID) references Branch,
) ;
6. Car Specifications:
Model's-ID
Capacity Door Car-Steering Windows Cost / Hour Branch - ID
Number (8)
Varchar2 (10) Varchar2 (8) Varchar2 (12) Varchar2 (10) Varchar2 (16) Number (7)
Create table Car Rent Specifications (
Model's-ID Number (8),
Capacity Varchar2 (10),
Door Varchar2 (8),
Car-Steering Varchar2 (12),
Windows Varchar2 (10),
Cost / Hour Varchar2 (16),
Branch - ID Number (7),
Primary key (Model's-ID),
Foreign key (Branch - ID) references Branch,
) ;
10. Physical Database Design:
Process of producing a description of the implementation of the database on secondary storage; it describes the base relations, file organizations, and indexes used to achieve efficient access to the Data , and any associated integrity constraints and security measures.
10.1 Physical Database Design Steps:
Overview of Physical Database Design Methodology:
Step -1: Translate global logical data model for target DBMS: To produce a relational database schema that can be implemented in the target DBMS from the global logical data model. Need to know functionality of target DBMS such as how to create base
Step -A: Design base relations: To decide how to represent base relations identified in global logical model in target DBMS.
Step -B: Design representation of derived data: To decide how to represent any derived data present in the global logical data model in the target DBMS.
Step -C: Design enterprise constraints: To design the enterprise constraints for the target DBMS. Some DBMS provide more facilities than others for defining enterprise constraints.
Step -2: Design physical representation:
Step -A: Analyze transactions:
To understand the functionality of the transactions that will run on the database and to analyze the important transactions.
Step -B: Choose file organizations:
To determine an efficient file organization for each base relation. File organizations include
Heap, Hash, Indexed Sequential Access Method (ISAM), B+-Tree, and Clusters.
Step -C: Choose indexes:
To determine whether adding indexes will improve the performance of the system. One approach is to keep topples unordered and create as many secondary indexes as necessary.
Step -D: Estimate disk space requirements:
To estimate the amount of disk space that will be required by the database Step -3: Design user views:
To design the user views that was identified during the Requirements Collection and Analysis stage of the relational database application lifecycle.
Step -4: Design security mechanisms:
To design the security measures for the database as specified by the users: - System security. - Data security.
Step -5: Consider the introduction of controlled redundancy:
To determine whether introducing redundancy in a controlled manner by relaxing the Normalization rules will improve the performance of the system.
Step -6: Monitor and tune the operational system:
To monitor operational system and improve performance of system to correct inappropriate design decisions or reflect changing requirements. Mayflower wishes to hold pictures of properties, and comments that describe main features of property.
Comparison of Logical and Physical Database Design:
Database design methodology:
- A structured approach that uses procedures, techniques, tools, and documentation aide
to support and facilitate the process of design:
- Conceptual databas design.
- Logical databas design.
- Physical database design.
- Sources of information for physical design process include global logical data model and documentation that describes model. Logical database design is concerned with the what; physical database design is concerned with the how.
- Logical database design is concerned with what. - Physical database design is concerned with how.
- Physical database designer must know how the computer system hosting the DBMS
Operates.
-There is often feedback between physical and logical and application design, for
example decisions.
- Derive a logical model from the information represented in the ER model (conceptual
model).
- Physical database design: Process that is description the database implementation, and
describes the base relation and files organizations and indexes, and describes the base
constraints and security measures. Process of specifying and implementing the database on secondary storage; it describes the base relations, file organizations, and indexes used to achieve efficient access to the data, and any associated integrity constraints and
Security measures.
- Mapping from conceptual model to logical model mainly involves:
- Designing tables with primary keys.
- And linking tables with foreign keys.
- Logical Database Design: Translate a relational database model into a technical file and database design that balances several performance factors. Choose data storage technologies that will efficiently, accurately and securely process database activities.
File Organization Types:
1- Heap. 2- Hash. 3- Indexed Sequential Office Access Method. (ISAM). 4- B-tree. 5- Clusters.
Types of Index:
1- Primary Index.
2- Clustering Index.
3- Secondary Index.
Secondary Index:
Hash File:
Physical Representation:
Example of file representation for data in Customer table.
Tests Results:
Reports:
Security Mechanisms:
Data is a valuable resource that must be strictly controlled and managed, as with any corporate resource. the Part or all of the corporate data may have strategic importance and therefore needs to be kept secure and confidential. Therefore Mechanisms that protect the database against intentional or accidental threats that must available. Security considerations do not only apply to the data held in a database. Breaches of security may affect other parts of the system, which may in turn affect the database. What is "threat"?
Any situation or event, whether intentional or unintentional, that will adversely affect a system and consequently an organization or company.
Figure-2: Database Security.
Three very brood issues in DB Security:
1. Legal and Ethical considerations: who has the right to read what information?
2. Policy issues: Who should enforce security (government, corporations, and department)?
3. System level issues: where should security be enforced in the System and How?
security is very important because it is keeps the security of the system very strong , such as : in this system first the login screen , that ask the staff (admin) enter the user name and password and if two correct then press the login button to login the system. after that the staff can make the added and delete and another operations in the system.
Figure-2: Login Screen.
in mayflower company the DBA can delete , insert ,read,modify,search : about the customer, car model's,and branch.and the staff(admin)in each branch can make just add customer ,search about car model's, and see the all information but didn't delete any things just DBA can delete. The customer can make just search about car model’s, and Branch of the company.
Actions Customer Admin ADB Read N Y Y Insert N Y Y Modify N N Y Delete N N Y Search Y Y Y
User Guide (How Use the System):
Main Operations:
1. Entering the System:
2. Search about the company Branches:
3. Search about the Car Model's and car Options:
4. Querying about the method to pay cost of rental the car (cash or credit card):
5. Querying about another company services (such as: coach rental):
Conclusion and Recommendation:
These system talks about the car rental company in Malaysia called Mayflower Company. in these system I design the prototype of the company using the database , and discussion the all steps of the database design from the first steps conceptual database design ,and the logical database design ,to the last step the physical database design. and the main phases of each steps and many examples.
Remember that the goal of the DB development is to produce a DB that provides an important resource for an organization. The DB should be designed so that it can serve the customers and other team members efficiently.
Reference:
(Company Profile): http://www.mayflowercarrental.com.my/cr_about.asp
(Company Branch): http://www.mayflowercarrental.com.my/cr_branches.asp
(Car Model): http://www.mayflowercarrental.com.my/cr_model.asp
(Mayflower Company): http://www.mayflower.com.my/main/about.asp
(Mayflower Car Rental): http://www.mayflower.com.my/main/carRental.asp
