TYBCS PHP 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 : _________________ 

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 1 st rank in that competition.