LAB COURSE III INTERNET PROGRAMMING, NETWORKING & PROJECT - Assignment 5

Set A

Q: 1) Consider the following entities and their relationships

Emp (emp_no,emp_name,address,phone,salary)

Dept (dept_no,dept_name,location)

Emp-Dept are related with one-many relationship Create a RDB in 3NF for the

above and solve following

Using above database write a PHP script which will print a salary statement in the

format given below, for a given department. (Accept department name from the

user).

Deparment Name : _________________

Maximum Salary Minimum Salary Sum Salary

Q: 2) Consider the following entities and their relationships

Doctor (doc_no, doc_name, address, city, area)

Hospital (hosp_no, hosp_name, hosp_city)

Doctor and Hospital are related with many-many relationship. Create a RDB in 3 NF

for the above and solve following

Using above database, write a PHP script which accepts hospital name and print

information about doctors visiting / working in that hospital in tabular format.

Set B

Q: 1) Considerer the following entities and their relationships

project(pno integer, p_name char(30), ptype char(20),duration integer)

employee (eno integer, e_name char (20), qualification char (15), joindate date)

The relationship between project - employee: M-M, with descriptive attributes as

start_date (date), no_of_hours_worked (integer).

Using above database write a script in PHP to accept a project name from user and

display information of employees working on the project.

Q: 2) Consider the following entities and their relationships

student (sno integer, s_name char(30), s_class char(10), s_addr char(50))

teacher (tno integer, t_name char (20), qualification char (15),experience integer)

The relationship between student-teacher: m-m with descriptive attribute subject.

Using above database write a script in PHP to accept a teacher name from user

and display the names of students along with subjects to whom teacher is teaching

Set C

Q: 1) Consider the following entities and their relationships

Movie (movie_no, movie_name, release_year)

Actor (actor_no, name)

Relationship between movie and actor is many – many with attribute rate in Rs.

Create a RDB in 3 NF for the above and solve following

Using above database, write PHP scripts for the following:(Hint: Create HTML form

having three radio buttons)

a) Accept actor name and display the names of the movies in which he has

acted.

b) Insert new movie information.

c) Update the release year of a movie. (Accept the movie name from user)

Q: 2) Considerer the following entities and their relationships

Student (Stud_id,name,class)

Competition (c_no,c_name,type)

Relationship between student and competition is many-many with attribute rank and

year. Create a RDB in 3NF for the above and solve the following.

Using above database write a script in PHP to accept a competition name from user

and display information of student who has secured 1st rank in that competition.