StudentUniversity Application

a) 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

b) Create a Windows application. Add a top level menu item called InitializeDB with ten menus

underneath it for populating the ten tables. Each menu under InitializeDB reads data from a

text file and inserts a record (or updates it) in the corresponding table. When you click on the

menu, user is prompted to select the text file via an OpenFileDialog. The ten text files for each

table are comma separated and appear as shown below.

Students.txt

123451,Bill,Baker,45 Main Street,Bridgeport,CT,203-555-1234

123452,Mark,Mathews,25 Pine Street,Bridgeport,CT,203-555-7765

123453,Sally,Simpson,45 Oak Street,Stratford,CT,203-555-1242

123454,Cindy,Wiiliams,55 Center Street,Milford,CT,203-555-7741

123455,John,Jacobs,22 Rose Street,Bridgeport,CT,203-555-4420

Departments.txt

1001,Computer Science

1002,Computer Engineering

1003,Electrical Engineering

1004,Math

1005,Technology Management

Professors.txt

10001,John,Jacobs,20 University Avenue,Bridgeport,CT,203-555-1134

10002,Sara,Sorento,28 Hall Street,Bridgeport,CT,203-555-3362

10003,Hong,Wong,46 Main Street,Bridgeport,CT,203-555-1222

10004,David,King,55 Meadow Street, Shelton, CT,203-777-8126

Courses.txt

CPSC 410,Java Programming,3,Intermediate level Java Programming,1001

CPSC 411,Advance Java,3,Advance level Java Programming,1001

CPSC 440,Windows Programming,3,Intermediate level C# Programming,1001

CPSC 555,Web Application Development,3,Web Development,1001

Math 301,Differential Equations,3,Solving Differential Equations,1004

ELEG 443,Digital Signal Processing,3,Digital Signal Processing and its Applications,1002

CoursePrerequisites.txt

CPSC 555,CPSC 410

CPSC 555,CPSC 440

ELEG 443,Math 301

CPSC 411,CPSC 410

CoursesOffered.txt

CPSC 410,Fall 2016,35,28,Dana 123,10001

CPSC 411,Fall 2016,30,27,Tech 116,10001

CPSC 440,Fall 2016,45,44,Dana 123,10002

Math 301,Fall 2016,25,18,Carlson 152,10004

CPSC 555,Fall 2016,40,37,Tech 116,10002

ELEG 443,Fall 2016,25,20,Carlson 152,10004

CoursesTaken

123451,CPSC 440,Spring 2016,B-

123451,CPSC 410,Spring 2016,B+

123451,MATH 301,Summer 2016,B

123452,CPSC 410,Spring 2016,C

123453,Math 301,Summer 2016,A-

StudentCourses

123451,ELEG 443,Fall 2016

123454,CPSC 410,Fall 2016

123452,CPSC 411,Fall 2016

123454,CPSC 440,Fall 2016

StudentMajors

123451,1001

123452,1001

123453,1002

123454,1003

123455,1004

ProfessorDepartments

10001,1001

10002,1002

10003,1001

10004,1003

c) Create a top level menu item called “Student Management”. It will have two submenus in it.

1. View Students

Allows you to select a department, and view Students in the department via a

DataGridView.

2. View Student Grades

Allows you to search a student via a text box and then display the courses taken by the

student and the grades obtained in a DataGridView.

d) Create a top level menu item called “Course Management”. It will have two submenus in it.

1. View Courses Offered

A semester drop down will show semesters. Then depending upon the semester

selected in the drop down, the courses being offered in that semester will be shown.

2. View Enrollments

A course number drop down will show the courses being offered in the semester being

selected in another drop down. Then based on the two drop downs, you will show the

enrollment in the course selected. The course number drop down should dynamically

change when the semester drop down changes the semester.