CS403 Current Midterm Paper Fall 2013 File 13

custId	custName	custAddress
Cus101	ABC	LAHORE
Cus102	DEF	KARACHI
Cus103	GHI	LAHORE
Cus104	JKL	ISLAMABAD

PRID	PRNAME
PR101	SHAMPO
PR102	SOAP
PR103	PERFUME

ɚ(custAddress=’Lahore’)CUSTOMR X PRODUCT  (5)

COURCE , MGT,COMPUTER SCIENCE, MATHEMATICS

DRAW THE SUPER TYPE AND SUBTYPE DIAGRAM FOR THESE ENTITIES  (3)

Convert the following table into next normal form . if in 1^st normal form then in 2^nd if in 2^nd normal form

Then in 3^rd normal form.

Stdid	stdName	stdAdd	Hobby
1	Abc	Xyz	Movie Reading
2	Def	Abc	Football Basketball
3	Ghi	abc	Body building Movie Cricket
4	gkl	jkl	cricket

DRAW THE ENTITY RELATIONSHIP DIAGRAM FOR THE FOLLOWING CASES (5)

1. A sales invoice is written by one salesman and a salesman can write one or more invoices
2. A product is purchased from one vendor and vendor can sale one or many products
3. A sales invoice may contain one or many products and a product may appear as zero or many invoices

What is semi join (2)

1. Contractual
2. Hourly
3. Permanent

These are the categories of employees that are working on a project. Some employees are assigned the job of consultant on the project then which one constraint will apply.

Total completeness,

Partial completeness

Total overlapping

Partial overlapping -------------------------------------------------------------------------------(2)