Skip to content

Database Systems

SWE · Quiz · Fall 25

Paper 1 of 3Section 43-D · Kawsher HRidoy (1)Switch

Section 43-D

Paper 1 of 3

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.

Daffodil International University Department of Software Engineering Quiz-1, Fall-2025 Course Title: Database System Course Code: SE 223 Section: 43-D Teacher: CP Time: 30 Minutes Marks: 15 ID: ________________________________ Sec: _____________ [The figures in the right margin indicate the full marks. Responses must be written in the designated space, as no additional pages will be provided] Q-1: League_1 Player ID | Name | Age | Team Name 1 | Rahim | 25 | Dhaka Warriors 2 | Sumon | 28 | Comilla Victorians 3 | Imran | 30 | Dhaka Warriors League_2 Player ID | Name | Age | Team Name 1 | Arif | 24 | Chittagong Kings 2 | Rafi | 28 | Chittagong Kings 3 | Alve | 23 | Durdanto Rajshahi Using Relational Algebra, 1. Display the player names along with their corresponding team names from the League_1 table. [1] 2. Display the player names from the League_2 table where the age is between 22 and 25. [1] 3. Display the names and ages of the players who play for Chittagong Kings. [2] 4. Display the names and ages of all players from both tables. [2] 5. Display the ages from League_2 table that are not present in League_1 table. [2] Q-2: Assume a Sports Management System where each team can have many players, and each league contains many teams. One player plays for only one team, and one team plays in only one league. One coach trains one team, and one team can play against one team at a time. Players are attributed with Player_Name, Player_ID, Phone, Age, Date_of_Birth, and Address, where Address is further divided into Present_Address and Permanent_Address. Leagues are attributed with League_Name, League_ID, Country and Establishment_Year. Each Team is attributed with Team_Name, No_of_Domestic_Players and No_of_International_Players. Coaches are attributed with Coach_ID, Coach_Name, Team_Name and Years_of_Experience. Now, draw an ER diagram denoting the entities, types of attributes and proper cardinalities based on the above description. [7]