Skip to content

Database Management System

CSE · Quiz · Fall 24

Section 63_G

This browser can’t show the PDF here

Open it, and your phone’s PDF viewer takes it, or download it.

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]