Lab 4: Student Information System (SIS) – database

Lab 4: Student Information System (SIS) – database

Student Information System (SIS) – Database

Tasks

Scenario (People / Tech / Process / Data)

• People: students, faculty, registrar, IT support
• Tech: simple web portal + SQLite database (Software DB Browser for SQLite )
• Process: enroll, drop, grade submission
• Data: student profiles, faculty profiles, courses, seats/capacity, enrollments, grades

What your SIS must do

• Add Students
• Add Faculty
• Add Courses (with a capacity and a faculty teacher)
• Student can Enroll in a course
• Student can Drop a course
• Faculty can Submit Grades
• Reports:
  • Seats remaining per course
  • Student transcript (courses + grades)

Constraints

• Use a primary key for each table
• Use foreign keys to connect tables
• Students Courses is many-to-many, so you must use a bridge table (Enrollments)
• Prevent duplicate enrollments in the same term

Tips

Step 1) Identify Entities (Tables)

Step 2) Relationship Types (1:M and M:N)

Step 3) Choose Primary Keys + Foreign Keys

Step 4) Add a Rule to Prevent Duplicate Enrollment

Struggling with your essay and deadlines?

Get this or a similar paper done in as fast as 4 hours, 24/7.

NB: We do not sell prewritten papers. All essays are written from scratch according to specific needs and instructions

✔Secure Service ✔ Plagiarism Free ✔On-time Delivery

WRITE MY PAPER