Database Management System
CSE · Quiz · Fall 24
Section 63_G
Read the questions as text
Read off the PDF by AI, so it may have mistakes. The PDF is the original.
CSE311, Database Management System, Fall '24
Section: 63_G Quiz-1 Date: 17.09.2024
Marks: 15 Time: 35 Minutes
Q1. Describe the architecture of Database Management System - DBMS [4]
Q2. "In the FIFA World Cup database, there are several key entities: Teams, Matches, Players, and Tournaments. Each Tournament has a unique identifier and a date range. Teams are associated with Tournaments through participation records and have attributes such as team name and country. Matches occur during a Tournament and involve two Teams; each Match has attributes like date, location, and scores. Players are linked to Teams and have attributes such as player name, position, and nationality. The relationships include 'Participates' between Teams and Tournaments, 'Plays' between Teams and Matches, and 'Includes' between Matches and Players."
This paragraph outlines the main entities and their relationships. Now, design an ERD based on the above scenario. Be certain to indicate primary keys and cardinality constraints. [6]
Q3. [Figure: An Entity-Relationship Diagram showing Student and Book entities with their attributes and the Reads relationship]
Convert the ERD into a relational database schema. Be certain to indicate primary keys and foreign keys. [5]