Q1.

A). Explain characteristics of debase approach versus the file processing approach? ( Short, To The Point ).

B).Create database with Name Saim132

Create Schema the following schemas I) Student (Student_id, name,gender , age, address) II) Course (course_id, name, credit hours) ii) Department (id, Name, location) Insert at least 6 dummy record in schemas having first record your own information in students table. Write down queries for the following statements.

a) Select (name age) from Student Table and (Course name) form Course Table and (department name) from Department table write suitable join for the statement. (Attach screen shot of your work)

b) Select (name, age) from student table and (course, credit hours) from course table with the help of sql join query, assign all course subjects to yourself only(Courses:: Technology Management , Software Engineering-II , C-Modern Programming Language-I , Operating Systems , Web Systems and Technologies , Database Administration & Management). (Attach screen shot of your work)

c) Select top 3 records with minimum age and maximum age from student table.(Attach screen shot of your work)