Combinestudy

Q 1:  Write SQL statements/queries for each of individual scenario given below from the given tables on the next page. 15 marks (3+4+4+4)

1. Create a  simple view showing the names of employees whose designation is ”Instructor”

2. Create a view to list down employees name and designation  of Computer sciences ....

Q 1:  Write SQL statements/queries to show the data for each of individual scenario given below from the given tables on the next page. 15 marks (3+3+3+3+3)

1. Show all the Instructor names with their taught Course IDs, Course Names and their concerned departments. 

2. Show all the instructor names and their concerned ....

Q 1: Normalize the below table up to 3rd normal form.(7.5+7.5)

Guidelines / Instructions

• Understand the scenario on the basis of given data only.

• The relation is already in 1st normal form and has composite Primary Key.

• Don’t convert the relation in to 3rd normal form directly. ....

Q Draw an E-R diagram for each of the following situations:

a. In an Organization each of Corporation division is composed of many departments. Each of the departments has many employees assigned to it, but each employee works for only one department. The attributes of EMPLOYEE include NAME, ADDRESS, BIRTHDATE and the attributes of DEPARTMENT are DEPT_NO and DEPT_NAME.   5 Marks

b.

Q. Draw a Context as well as Level 0 Data Flow Diagram (DFD) of any DVD rental System. 

Guidelines / Requirements:

The context level diagram must contain a major process and external entities.

Level 0 diagram must consist of major functions and should work as follows: 

 There should be 2 streams, or flows of data. (i) The customer request to rent a DVD, system check the ....