Practice & Assessment
Test your understanding of Introduction to Database Management Systems
Multiple Choice Questions
5What is the primary advantage of a DBMS over a file system?
Which type of NoSQL database is best suited for a social network's friend-of-friend relationship queries?
In the relational model, what is a tuple?
What does the ANSI-SPARC three-level architecture provide?
Which property distinguishes RDBMS from most NoSQL systems?
Coding Challenges
1Create Your First Database Schema
Design and create a simple library management database. Write SQL DDL statements to create the following tables: (1) books — with book_id (primary key), title, author, isbn, published_year, and available_copies. (2) members — with member_id (primary key), name, email, phone, and join_date. (3) loans — with loan_id (primary key), book_id (foreign key), member_id (foreign key), loan_date, and due_date. Insert at least 3 sample rows into each table and write a SELECT query to retrieve all currently loaned books with the member name who borrowed them.
Mini Project
Student Management System Database
Design and implement a complete Student Management System database. The system must include: (1) students table — student_id, first_name, last_name, email, date_of_birth, enrollment_date, and program_id. (2) programs table — program_id, program_name, duration_years, department. (3) courses table — course_id, course_name, credits, instructor_name, semester. (4) enrollments table — enrollment_id, student_id, course_id, enrollment_date, grade. Write queries to: fetch all students in a specific program, calculate the average grade per course, find students with GPA above 3.5, and list all courses a specific student is enrolled in. Document the relationships with a simple ER description.