Relational Design

Релациска шема (со мапирачка трансформација)

• Bold и Italic-> Key attribute
• Bold и * -> Foreign key
• Bold -> required

---

• Users(user_id,email,username,first_name,last_name,password,created_on,modified_on)
• Clients(user_id*)
• Business_Users(user_id*)
• Administrators(user_id*)
• Delivery_Man(user_id*,business_user_id*,company_id* ,salary,date_of_employment)
• Companies(company_id,company_name,company_email,created_on,created_by,user_id*,modified_on,modified_by,administrator_id*)
• Vehicles(vehicle_id,chassis_number,vehicle_type,fuel_efficiency,company_id*,model_id* ,registration_id*,brand,price)
• Models(model_id,model_name,year,color,number_of_seats,number_of_doors,fuel,transmission,vehicle_type)
• Registrations(registration_id,plate_num,registred_on,valid_thru,is_available)
• Payment_Cards(card_id,card_number,cvc,valid_thru,holder_name,user_id*)
• Locations(location_id,company_id*,city,street,street_number)
• Payments(payment_id,card_id*, payment_date,time)
• Contracts(signed_date,user_id*,vehicle_id*,deliveryman_id*,payment_id*,card_id*,address,from_date,to_date)
• Is_responsible_for(user_id*,vehicle_id*)

DDL скрипта за бришење на табелите и креирање на табелите

kreiranje.sql

DML скрипта за полнење на табелите со податоци

polnenje.sql

Релациски дијаграм изваден од DBeaver