Their profiles and prices and book from them identifying the location
The centre has a number of accommodation options: a four star hotel; a hostel with large dormitories for children and smaller shared rooms for supervising adults; and a small camping ground. The name and type of these options is stored, along with the total number of people they can accommodate.
Each booking has a unique booking number, the date that booking was made, and the dates of the stay. When making a booking, clients state how many people will be staying, and what type of accommodation is required. They also say whether they will use the restaurant or self-catering facilities. The booking will also include any additional facilities required by the client.
Write a query to find which Customer has made the most bookings in the last 6 last months.
Write a query to find what is the average age of staff who are assigned to work on the outdoor pursuits.
Football championship calendar
This project supposed to develop a database system for football championship calendar. The system contains information about teams, stadiums, referees, and matches. A match is composed by local team, visitor team, date of match, referee and stadium and the score. You should design the system to contain entities and attributes to store data that makes the system able manage the championship and to organize the different matches. Note that the winner has 3 points and the loser 0 point. In draw case, 1 point for each team. The referee is identified by his ID. The team is identified by his name.
Insert the matches of the next journey and the date.
List the available stadium with the capacity.
Each course has id, title, credit hour.
You should store an id, name, email for each student.
Database should also store the various activity grades for each student.
SQL Queries:
5. Show the students who obtained grades less than 60 in “physics” course.
Project 4
Each Car is described by type (e.g. sedan, pickup, truck etc.), brand name, class, model, color, fuel type, current odometer, rental fee per day, location, plate number, vehicle identification number VID and expiry date of vehicle registration. Both VID and plate number are unique for each car.
The customers can register, view available cars, their profiles and prices and book from them by identifying the location, pick-up and return date and time.
The customer can evaluate the car (out of 5 stars) and write a feedback after returning it.
You should design the system that contain entities and attributes to store data that makes the system able to report the requested information by executing the following queries.
List all bookings for a particular customer.
List the name of all customers who have rented cars via the online system in the past month.
III. | Your Project: |
---|
Normalize the Tables (in 3NF at least)
Create the Normalized Tables and Populate them with at least 5 Rows