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