SUBJECT: DATABASE MANAGEMENT SYSTEM QUESTION NO 1: Suppose you assigned a task to design relational schema by consider the domain of Bahria University and consider the information of student,...

SUBJECT: DATABASE MANAGEMENT SYSTEM

QUESTION NO 1:

Suppose you assigned a task to design relational schema by consider the domain of Bahria University and consider the information of student, employee, campuses, departments, and programs and then normalize these relations up to third normal form

QUESTION NO 2:

Suppose you assigned a task to design relational schema by considering the domain of product manufacturing company by considering the information of clients, branches, employee, products, and human resource then identify sample dependencies(if any) associated with BCNF and 4th Normal form and then remove those dependencies in order to transform the schemas into BCNF and 4th Normal Form also.