dbms presentation of automatic car parking system
TRANSCRIPT
1Auto car parking system
Auto Car parking system
2Auto car parking system
Name Id
Mst.Jannatul Ara 13103030
3Auto car parking system
Introduction
In metropolitan cities, car parking has
become a major concern in all busy areas
and a good traffic system needs a good
parking system. Different types of vehicle
parking are applied worldwide namely
Multi-level Automated Car Parking,
Automated Car Parking System,
4Auto car parking system
System benefit
• Quick Automated Parking and retrieval of vehicles.
• Does not require a parking attendant.
• Low maintenance levels required by the system.
• It will save our time.
• The system maintains whole system properly.
• Keep all records properly.
• The system has backup file.
• The system is secured.
5Auto car parking system
Entity and Attribute
Entity and attribute of auto car parking system
Car owner-Owner Name, Owner id,Address,p-number,car
number.
Car-Car brand, Car number, car color.
Parking Floor –floor name, floor id,number of slot,floor
number.
Parking style-style name , style Id,parking floor,parking rate.
6Auto car parking system
E-R diagram
7Auto car parking system
Normalization
Database normalization is a technique of organizingthe data in the database.
Normalization is used for Mainly two purposes:
Eliminating redundant data.
Ensuring data dependencies make sense.
Normalization rule:
Normalization rule are divided in following form
1NF
2NF
3NF
BCNF
8Auto car parking system
1NF
Partial dependency:
• Owner id-owner name,address,phone number,car number.
• Car number-car band,car color
• Floor id-floor name,number of slot
• Style id-style name,parking rate
Transitive dependency:Style name-parking rate
9Auto car parking system
2NF
10Auto car parking system
3NF
11Auto car parking system
How can we website run
• Step 1 : past php mysql code into c drive XAMPP > htdocs
• Step 2: open browser and type -http://localhost/phpmyadmin
• Step 3 : create Database > Database name Must be : car_parking
• Step 4 : Select car_parking database and import database, you can find it carparking folder > Database
• Step 5 : http://localhost/carparking
12Auto car parking system
Website snapshot
13Auto car parking system
Website snapshot
14Auto car parking system
Auto car parking system 15
Auto car parking system 16