design and present a DBS to track students attending classes a CSC class that has a maximum of 21 students and meets 32 times a term. I need to be able to generate 3 reports as follows:

1. A roster of all students attending class on a given date.

2. A list of all class dates a given student attended.

3. A Report that tells me how many students attended each date of the class.

Create the following deliverables:

The SQL Data Definition Language (DDL) statements

The SQL Data Manipulation Language (DML) statements.

SQL server or MS access

Here is an example of what the DDL and DML should look like:

  

Transcribed Image Text:

Create Database AIRPORT_OPS; Create Table Airport (Acode Char (3), Aname Char (20), Constraint A_PK Primary Key (Acode)); Create Table Flight (Fnumber Char (6), Airline Char (20), D_Airport Char (3), A_Airport Char (3), Constraint F_PK Primary Key (Fnumber), Constraint D_FK Foreign Key (D_Airport) References Airport (Acode), Constraint A_FK Foreign Key (A_Airport) References Airport (Acode)); Insert into Airport Values ('SEA', 'Seattle'); Insert into Airport Values ('DIA', 'Denver'); Insert into Airport Values ('PHX', Insert into Airport Values ('PDX', Insert into Airport Values ('ORD', 'Phoenix'); 'Portland'); 'Chicago'); Select * from Airport; Create Database AIRPORT_OPS; Create Table Airport (Acode Char (3), Aname Char (20), Constraint A_PK Primary Key (Acode)); Create Table Flight (Fnumber Char (6), Airline Char (20), D_Airport Char (3), A_Airport Char (3), Constraint F_PK Primary Key (Fnumber), Constraint D_FK Foreign Key (D_Airport) References Airport (Acode), Constraint A_FK Foreign Key (A_Airport) References Airport (Acode)); Insert into Airport Values ('SEA', 'Seattle'); Insert into Airport Values ('DIA', 'Denver'); Insert into Airport Values ('PHX', Insert into Airport Values ('PDX', Insert into Airport Values ('ORD', 'Phoenix'); 'Portland'); 'Chicago'); Select * from Airport;

Answer rating: 100% (QA)

To create a database system DBS to track students attending a CSC Computer Science class that has a ... View the full answer