Imagine that you are hired to create a basic database and a basic report for a school. In the SQL comments at the top of the script, write a short description of the school, and how the database is used by the school personnel. (some examples: “This database is used to register new students at Dog Obedience School”, “The Beauty Academy database determines how much revenue each class generates”, “Lucky Brake Driving School Database tracks accident rates across classes”, “CUNY SPS BSIS program could track per cent of students working in the field that have taken this course”, etc.
You should create and populate tables - using SQL exclusively - for Courses and Students. Each table should contain at least four or five rows.
You are encouraged to add one or more new columns that would be of interest to the people who use the information in your database, as you have described in number one above.
Write a SQL Query that shows which students are taking which courses.
You need to create an additional table to fulfill the additional requirements listed below.
One student should be able to register for more than one course; and
One course should be able to be taken by more than one student.
The student table should have not duplicate students. The course table should have no duplicate courses.