[go: up one dir, main page]
Scribd
Upload
91 views3 pages

Bahria University (Karachi Campus) : Midterm Examination - Spring Semester - 2020

Uploaded by

Madiha Farhad

This document contains instructions for a database management systems midterm exam assignment. Students are asked to: 1) Describe their semester project including the purpose and business rules of a commercial application they studied. 2) Draw an entity relationship diagram for their project demonstrating various relationship types. 3) Normalize several relationships up to the BCNF including tables for pet health history, property rentals, and invoices. 4) Normalize a report used by a grocery store manager to determine product prices.

Copyright:

© All Rights Reserved
Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt

Bahria University (Karachi Campus) : Midterm Examination - Spring Semester - 2020

Uploaded by

Madiha Farhad
91 views3 pages
This document contains instructions for a database management systems midterm exam assignment. Students are asked to: 1) Describe their semester project including the purpose and business rules of a commercial application they studied. 2) Draw an entity relationship diagram for their project demonstrating various relationship types. 3) Normalize several relationships up to the BCNF including tables for pet health history, property rentals, and invoices. 4) Normalize a report used by a grocery store manager to determine product prices.

Original Title

DBMS-Exam-Assignment-12052020-100848pm (1)

Copyright

© © All Rights Reserved

Available Formats

DOCX, PDF, TXT or read online from Scribd

Did you find this document useful?

Is this content inappropriate?

This document contains instructions for a database management systems midterm exam assignment. Students are asked to: 1) Describe their semester project including the purpose and business rules of a commercial application they studied. 2) Draw an entity relationship diagram for their project demonstrating various relationship types. 3) Normalize several relationships up to the BCNF including tables for pet health history, property rentals, and invoices. 4) Normalize a report used by a grocery store manager to determine product prices.

Copyright:

© All Rights Reserved
Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt
91 views3 pages

Bahria University (Karachi Campus) : Midterm Examination - Spring Semester - 2020

Uploaded by

Madiha Farhad
This document contains instructions for a database management systems midterm exam assignment. Students are asked to: 1) Describe their semester project including the purpose and business rules of a commercial application they studied. 2) Draw an entity relationship diagram for their project demonstrating various relationship types. 3) Normalize several relationships up to the BCNF including tables for pet health history, property rentals, and invoices. 4) Normalize a report used by a grocery store manager to determine product prices.

Copyright:

© All Rights Reserved
Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt
You are on page 1/ 3

BAHRIA UNIVERSITY (KARACHI CAMPUS)

MIDTERM EXAMINATION –SPRING SEMESTER – 2020


(Database Management System)

Take Home Assignment

Class: BS (CS) – 4 (A,B) (Morning)


Course Instructor: Malik M Ali Submission Deadline: 31-May-2020
Max Marks: 20

1. Describe your semester project. It must include [Marks: 05]


a. Project purpose,
b. Provide detailed screenshots along with the website link of the application you have
studied for requirement gathering and understanding business rules of your project
business domain. The application must be a commercial application making money for
some business.
c. Identify business rules of the application studied.
2. Draw a comprehensive Entity Relationship Model using Crow’s Foot notation of the above
mentioned project. It must be accompanied by description of each Entity in a separate section
which includes Entity Name, Purpose and Attributes. The ER-Model must demonstrate
following relationships [Marks: 05]
a. Recursive binary, binary and ternary relationship
b. One – One, One – Many and Many – Many relationships
c. Existence of a relationship
d. Generalization and
e. Aggregation

3. Normalize following relationships up to BCNF [Marks: 10]


a. PET HEALTH HISTORY
PET ID PET NAME PET TYPE PET AGE OWNER VISIT DATE PROCEDURE
246 ROVER DOG 12 SAM COOK JAN 13/2002 01-RABIES VACCINATION
MAR 27/2002 10-EXAMINE and TREAT
APR 02/2002 WOUND
05-HEART WORM TEST

298 SPOT DOG 2 TERRY KIM JAN 21/2002 08-TETANUS


MAR 10/2002 VACCINATION
05 - HEART WORM TEST
341 MORRIS CAT 4 SAM COOK JAN 23/2001 01 - RABIES VACCINATION
JAN 13/2002 01 - RABIES VACCINATION
519 TWEEDY BIRD 2 TERRY KIM APR 30/2002 20 - ANNUAL CHECK UP
APR 30/2002 12 - EYE WASH

b. House owner, Client and Property Table

Page 1 of 3
ClientN propertyN pAddress rentStart rentFinish ren ownerN oName
o o t o
CR76 PG4 6 lawrence 1-Jul-00 31-Aug- 350 CO40 Tina Murphy
St,Glasgow 01
CR76 PG16 5 Novar Dr, 1-Sep-02 1-Sep-02 450 CO93 Tony Shaw
Glasgow
CR56 PG4 6 lawrence 1-Sep-99 10-Jun-00 350 CO40 Tina Murphy
St,Glasgow

CR56 PG36 2 Manor Rd, 10-Oct-00 1-Dec-01 370 CO93 Tony Shaw
Glasgow
CR56 PG16 5 Novar Dr, 1-Nov-02 1-Aug-03 450 CO93 Tony Shaw
Glasgow

c. Normalize the following Invoice up to 3NF

d. This report is used by the grocery store manager to determine the final selling price
of his products

Page 2 of 3
Supplier Code and Product Code and Name Cost Markup Price Dept
Name Code
21 – Very Veggie 4108 – tomatoes 1.89 5% 1.99 PR
32 – Fab Fruits 4081 – bananas 0.20 75% 0.35 PR
32 – Fab Fruits 4027 – grapefruit 0.45 100% 0.90 PR
32 – Fab Fruits 4851 – celery 1.00 100% 2.00 PR
08 – Meats R Us 331100 – chicken wings 0.50 300% 1.50 BU
08 – Meats R Us 331105 – lean ground beef 0.60 400% 2.40 BU
08 – Meats R Us 332110 – boneless chicken 2.50 100% 5.00 BU
breasts
10 – Jerry’s Juice 411100 – orange juice 0.25 400% 1.00 FR
10 – Jerry’s Juice 521101 – apple juice 0.25 400% 1.00 FR
45 – Icey Creams 866503 – vanilla ice cream 2.50 100% 5.00 FR
45 – Icey Creams 866504 – chocolate ice cream 2.50 100% 5.00 FR

Page 3 of 3

You might also like