Skip to content

Database Systems

SWE · Quiz · Fall 25

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

Section 43-D

Paper 3 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: Company_1 Employee ID | Name | Age | Department Name 1 | Anika | 26 | HR 2 | Rashed | 29 | IT 3 | Mizan | 31 | HR Company_2 Employee ID | Name | Age | Department Name 1 | Tania | 24 | Finance 2 | Arman | 31 | Marketing 3 | Farhan | 23 | Finance Using Relational Algebra, 1. Display the employee names along with their corresponding department names from the Company_1 table. [1] 2. Display the names of the employees from the Company_2 table where the name begins with 'A'. [1] 3. Display the names and ages of the employees who work in the Finance department. [2] 4. Display the names and ages of all employees from both tables. [2] 5. Display the ages from Company_1 table that are not present in Company_2 table. [2] Q-2: Assume a Movie Production System where each production company can produce many movies and each movie is directed by one director. Every movie features multiple actors and one actor can act in multiple movies. A director can choose multiple actors for a movie. A senior actor can mentor another junior actor. Movies are attributed with Movie_ID, Name, Release_Date and Budget. Production Companies are attributed with Company_ID, Name, Headquarters and Established_Year. Directors are attributed with Director_ID, Director_Name, Experience_Years and Awards_Won. Actors are attributed with Actor_ID, Actor_Name, Date_of_Birth, Phone and Address, where Address is further divided into Present_Address and Permanent_Address. Now, draw an ER diagram denoting the entities, types of attributes and proper cardinalities based on the above description [7]