[مخالف - طلب حل : ]شيت داتا بيز

السلام عليكم ورحمة الله وبركاته

ارجو الافادة ضروروي انا طالب بكلية الحاسبات والمعلومات وكان عندي شيت داتا بيز بس مش عارف احله خالص الشيت هو:

Answer the Following Questions:

1. Write an SQL script (DDL statements) to Create Database called Emp_database, contains the following two tables Employee (Emp_ID, Emp_Name, Salary, Dept_ID) and Department (Dept_ID, Dept_Name, Mgr), where Employee.Dept_ID is a foreign key references Department.Dept_ID and Department.Mgr is a foreign key references Employee.Emp_ID.

Write SQL statements to do the following:

i. Get names of all employees working on department which is managed by manager is 456.

ii. Update salaries of all employees working on department which has employee with highest salary.

iii. Delete from departments, where department contains min no of employees and min salaries paied to its employees.

Write an SQL query to select all employees and their departments, and all departments and their employees taken into consideration that some departments haven’t any employees and some employees aren’t in any departments.

1. Question I Draw a conceptual ERD for the following business scenario

Consider we have a collage with 4 departments, each department has around 20 students, and we want to make online examination.

1. Each student will have user and password

2. For each departments We will have 3 exams, the student can choose one of them ,

3. In the database we will add 100 questions for each exam ,But for each student, only 20 questions will be randomly chosen according to the exam (will be differ from a student to another).

4. The questions are multiple choice (3 are wrong ,1 is correct )

5. The time will be limited according to each exam questions.(may be the same exam ,but different time from student to another according to the questions )

6. The result of exam for each student ,will be saved as the following

A. List of exam questions for that student

B. Each question (the answer is right or wrong)

C. Time taken for each question

2. Using the ERD drawn in Question 1 Try to Produce the Physical one