Designing parking lot database using E-R -Draw the E-R diagram on paper using pen. Convert the E-R diagram you obtained at the end of the design into a relational database diagram. -Provide the E-R diagram and the relational database scheme. Use rectangle for entity sets and diamond for relation and ellipse for features in E-R diagram. Don't forget Showing properties and keys of entity and relationship sets. Do not forget to show The mapping cardinality types of relationship sets (1-m, m-1,m-m, 1-1) and entity sets relationship sets (all/some, all/some) with odd/even or thin/bold line, and virtual relationship sets with dashed line. - Customers name, email and phone information. - Plate number, brand, model, year, color and type of cars ('auto', 'minibus', 'truck', 'bus') information. - Employees' name, ID number, phone information. - The parking area is divided into one-car parking areas with lines, and each parking area has a unique number. given. Thus, the location information of the parked vehicles in the parking lot will be stored in the database. In addition, the following information should be kept in the database: - Customers can own more than one car. Every customer must have a car. The car can only have one owner. Every car must be owned. - Those working in the parking lot work in shifts. In other words, employees regularly work 5 working days a week. not in the form of 8:00 in the morning and 17:00 in the evening; They work at certain hours on certain days. For example, if an employee is working on the first week of December, 1.12.22 Thurs. and 2.12.22 Friday, 8:00-17:00, 3.12.22 Saturday, 17:00-24-00, 4.12.22 Sunday never work, 5.12.22 Monday at 22:00-8:00 am Tuesday, 6.12.22. So the start and end of shifts has dates and times. - Customers leave their parking vehicles and pay a parking fee when picking up their vehicles. The time (minutes) the vehicle stays in the parking lot is measured from the date of entry and exit from the parking lot. The parking fee schedule includes how much parking fee the customer will pay. - A car parked in the car park is picked up by one of the car park staff. When exiting the vehicle If the receiving employee is still there, that employee, if not, another employee delivers the vehicle to the customer. Vehicles left are parked in one of the numbered areas in the parking lot. Thus, the location of the vehicle can be easily reached. - When the vehicle is received, a unique number and entry date time is given to the customer. Parking tickets are provided. This parking ticket is taken back from the customer at the exit, the parking fee is calculated and a till roll is given to the customer. Till roll will have a singular number, the till roll number and the amount of the fee collected are stored in the database. In some cases, the fee collected may differ from the fee that should be charged according to the fee schedule. Therefore, the fee collected should be kept separately. - Car parking service is also provided in the parking lot with a monthly subscription method. In monthly subscription, customer information, vehicle information and the number of a particular parking space reserved for this vehicle is being recorded. No fee is charged for the entry and exit of the subscribed vehicles. Apart from that, all other operations are the same as for non-subscribed vehicles. Subscriber parking fee payments are received monthly andthey are given vouchers. - Parking fee schedule, consist of time intervals (in minutes) and the price list corresponding to that interval. . An example tariff for cars is as follows: o 0-15 min: free o 1660min:20 TL o 61-120 minutes: 25 TL 0121180min:30TL 0181 minutes and beyond: 50TL o Monthly subscription: 1000 TL - A sample tariff for minibuses is as followv: o 015min : free 01660min:40TL - 61-120 minutes: 50 TL 0121180min:60TL - 181 minutes and beyond: 100 TL o Monthly subscription: 2000 TL - Similar tariffs are defined for buses and trucks. - Vehicles of customers who do not pick up their vehicle for 1 week are towed to the "trustee" parking lot. Provided that customers pay their debts to the parking lot and the trustee's fees, They can be taken back from the parking lot. Here, the trustee's fees will not be kept in the database, but the date and time in which vehicles (Vehicles which are not being received by the customers.) are being towed to trustee and the trustee's parking lot name will be kept in the database. *NOTE : - The E-R diagram will be drawn on paper using pen. The photo will be taken an then shared. - Submit the E-R diagram and the relational database scheme .*
