Create a new database (named MyUniversity) Student (sid: integer, sname: string(100 chars), GPA: real, dateOfBirth: date, Did: integer, FirstYear: integer) Department (did: integer, dname: string(30 chars), capacity: integer) Course (cid: integer, cname: string(50 chars), credit: integer) Enroll (studentID: integer, courseID: integer, departmentID: integer, enrollmentDate: date, finalGrade: real) studentID, courseID, and departmentID in Enroll are foreign keys referencing the primary keys of the student, course, and department relations, respectively. Did in Student is a foreign key referencing the primary key of the department relation. Using SQL, insert (random but meaningful) data records in the above tables. Create at least four different courses that include Operating Systems (3 credit hours), Data Bases (4 credit hours), and Marketing (5 credit hours) courses – consider one more course. Create three departments that include a Computer Science department and a Business department – consider one more department. Add at least 15 students (divided on the three departments – 5 students for each department). Randomly distribute the value of the “First year” between 2016 and 2022. Each student has at least three different enrollments(each student is registered for three different courses). The enrollments should be between January 2020 and December 2020.
Create a new
Student (sid: integer, sname: string(100 chars), GPA: real, dateOfBirth: date, Did: integer, FirstYear: integer)
Department (did: integer, dname: string(30 chars), capacity: integer)
Course (cid: integer, cname: string(50 chars), credit: integer)
Enroll (studentID: integer, courseID: integer, departmentID: integer, enrollmentDate: date, finalGrade: real)
studentID, courseID, and departmentID in Enroll are foreign keys referencing the primary keys of the student, course, and department relations, respectively. Did in Student is a foreign key referencing the primary key of the department relation.
Using SQL, insert (random but meaningful) data records in the above tables.
Create at least four different courses that include
hours), and Marketing (5 credit hours) courses – consider one more course.
Create three departments that include a Computer Science department and a Business department –
consider one more department.
Add at least 15 students (divided on the three departments – 5 students for each department). Randomly
distribute the value of the “First year” between 2016 and 2022.
Each student has at least three different enrollments(each student is registered for three different courses).
The enrollments should be between January 2020 and December 2020.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
