Skip to content

Database Systems

SWE · Final · Fall 22

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 Faculty of Science & Information Technology Final Examination, Fall 2022 Course Code: SE223; Course Title: Database Systems Sections & Teachers: NJ Time: 2:00 Hrs Marks: 40 Answer ALL Questions [The figures in the right margin indicate the full marks and corresponding course outcomes. All portions of each question must be answered sequentially.] [Figure: Seller and Invoice tables] 1. a) A. Consider the following relation: I. Solve sql statement using subquery to find the seller name whose sold quantity more than any seller who sold at 11th December 2022. II. Solve sql statement using subquery to find the oniontype which are sold highest amount. III. Solve sql statement using subquery to find those sellername who sold at 11 th December 2019. IV. Solve sql statement to show the name of Seller who sells Indian Onion. V. Solve sql statement to find the Onion which has highest price than all others. VI. Solve sql statement to show the total price of each type onion those are sold. VII. Solve sql statement to find the store id which have more than one employee. VIII. Solve sql statement to show the price of onion which is more than 40 taka per kg. IX. Solve sql statement to find seller name and ID whose name starts with K. X. Solve sql statement to find the invoice info which price is in between 40and 190. XI. Solve sql statement to find the sellers whose name contains h in 3rd position XII. Solve sql statement to find the list of oniom using distinct. XIII. Solve sql statement to add a column address in the seller table XIV. Solve sql statement to delete data of Babul XV. Solve sql statement to find highest price. 2. a) Interpret functional dependency? Relate the functional dependency from the following relation? Student | StudentID | Student-name | StudentAddress | courseno | coursetitle b) Consider the Billing Receipt for Project Development Form given below: [Figure: Billing Receipt form showing Project No, Project Name, Bill No, Bill Date, Dept No, Dept Name, Dept Location, and a table of Employee No, Name, Responsibility, Rate/Hour, Chargeable Hour, Total, and Grand Total] Analyze the above scenario for project billing system and normalize the table up to Third Normal Form (3NF); explaining every steps of the process. c) Is there any composite key in the question b? briefly demonstrate with appropriate reason. d) List the rules of normalization and summarize why we need normalization to design database. e) Explain FOUR anomalies for the question b. f) Develop an ERD for the question b identifying entity, attributes, relationship and cardinality.