create a new database (named MyUniversity), the creation (using the CREATE command) should be done once. The database is now created and saved locally on your computer. When you close the workbench and reopen it again, no need to re-run this CREATE command again (the compiler will give you an error, as the database you would like to create was already created) Task Description: consider the following relations for a university: 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, create these relations under the MyUniversity database you created. Place the constraints (e.g., default values, check, primary keys) you find appropriate.
create a new
be done once. The database is now created and saved locally on your computer. When you close the workbench and reopen it again, no need to re-run this CREATE command again (the compiler will give you an error, as the database you would like to create was already created)
Task Description: consider the following relations for a university:
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, create these relations under the MyUniversity database you created. Place the constraints
(e.g., default values, check, primary keys) you find appropriate.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Using SQL, insert (random but meaningful) data records in the above tables.
• Create at least four different courses that include
• 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.
by Bartleby Expert
