Design UML for the following set of requirements for a university database that is used keep track of student’s transcripts. 1. The university keeps track of each student’s name, student number, social security number, current address and phone, permanent address and phone birthdate, sex, major department, minor department (if any), and degree program (B.A., B.S., Ph.D.). Both student number and social security number have unique values for each student. 2. Each department is described by a name, department code, office number office phone, Both name end code have unique values for each department 3. Courses are described by a course name, course number, credit hours and department. each course has one or more prerequisite course. 4. Each section has an instructor, semester (spring) , year , course , and section number. The section number is unique. 5. A grade report needs to be printed out to display the student number, the section and the numeric grade
Q3:
Design UML for the following set of requirements for a university
database that is used keep track of student’s transcripts.
1. The university keeps track of each student’s name, student number,
social security number, current address and phone, permanent
address and phone birthdate, sex, major department, minor
department (if any), and degree program (B.A., B.S., Ph.D.). Both
student number and social security number have unique values for
each student.
2. Each department is described by a name, department code, office
number office phone, Both name end code have unique values for
each department
3. Courses are described by a course name, course number, credit
hours and department. each course has one or more prerequisite
course.
4. Each section has an instructor, semester (spring) , year , course ,
and section number. The section number is unique.
5. A grade report needs to be printed out to display the student
number, the section and the numeric grade
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
