Create a database in your SQL Server using SQL Server Management Studio called UBDB. Create the following
Question:
Create a database in your SQL Server using SQL Server Management Studio called “UBDB”.
Create the following ten tables in it.
1. Students
StudentId varchar(10) Primary Key
FirstName varchar(50)
LastName varchar(50)
StreetAddress varchar(100)
City varchar(50)
State varchar(10)
Telephone varchar(20)
2. Departments
DepartmentId int Primary Key
DepartmentName varchar(20)
3. Professors
ProfessorId varchar(10) Primary Key
FirstName varchar(50)
LastName varchar(50)
StreetAddress varchar(100)
City varchar(50)
State varchar(10)
Telephone varchar(20)
4. Courses
CourseNum varchar(20) Primary Key
CourseName varchar(50)
CreditHours int
Description text
DepartmentId int
5. CoursePrerequisites
CourseNum varchar(20) Primary Key
PrereqCourseNum varchar(20) Primary Key
6. CoursesOffered
CourseNum varchar(20) Primary Key
Semester varchar(20) Primary Key
MaxEnrollment int
EnrolledCount int
RoomNumber varchar(20)
ProfessorId varchar(10)
7. CoursesTaken
StudentId varchar(10) Primary Key
CourseNum varchar(30) Primary Key
Semester varchar(20) Primary Key
Grade
8. StudentCourses
varchar(2)
StudentId varchar(10) Primary Key
CourseNum varchar(20) Primary Key
Semester
9. StudentMajors
varchar(20) Primary Key
StudentId varchar(20) Primary Key
DepartmentId
10. ProfessorDepartments
int Primary Key
ProfessorId varchar(10) PrimaryKey
DepartmentId int PrimaryKey
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last