Question: Required all Screenshots for below question: Implement the relational model of the following project into a database using Microsoft Access. The datasheet view of every
Required all Screenshots for below question:
Implement the relational model of the following project into a database using Microsoft Access.
The datasheet view of every table in your Access database oName the tables using the relation names in the relational model given.
o Create and show at least five data records for each table.
o Put the screenshots in alphabetical order of the table names, or points will be deducted.
The Relationships view of the Access database.
o Show the primary keys and the foreign keys of each table if any
o Show the relationships between tables.
The design view and the query result of all queries listed below.
o Implement the queries given below Page Queries and
o For the design view of each query, present the Table pane and the Design grid.
o The screenshots must be legible and clearly show your work.
o Please place the screenshots in the same order as the queries, or points will be deducted.
Relational Model
Oucries
Professors are interested to know their weekly schedule. Create a query that prompts for the professors' name and returns their weekly schedule.
Create a query that prompts for students' identification numbers and returns their timetables for the current semester.
For each course offered in the current semester, present the total number of students registered, the classroom capacity, and the classroom description. This query will help to identify possible changes to the timetable due to the class capacity or equipment computers video, etc. availability.
Create a query that prompts for the name of a department and course level freshmen senior and returns the timetable of the courses for this particular group. The results from this query are used to check whether the courses belonging to this particular group are assigned to the same class period.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
