Sql Projects

Classroom Database

Need an database to store class and student information and the books that they have written.

First Solution

You should populate the first three tables with sample data before you add data to the StudentClasses table. You will need the ids from all other tables to be able to insert correct data into StudentClasses.

If a student was taking a class, they would be inserted into a record on the StudentClassess table where the ClassRoomId and CourseId are required.

Tables Needed

Students

Id

FirstName

LastName

Mi

DOB

Phone

GradudationYear

Class Rooms

Id

Rm Number

BuildingName

Capcity

Courses

Id

Name

StudentClasses

StudentId

CourseId

ClassRoomId

Stored Procs Needed

Select All Student Information for students that have a Class

Select all the Class Room data for Classrooms that are associated with Course and Students

Select all the Course with students in them

Select all the students not in a class

Select all the students that are taking 1 particular class. Use the Class Id column to filter.