project1

Note that a department identified by deptid should

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: fier for the student (string) SNAME – name of the student (string) SLEVEL – year of the student in the department (Freshman, Sophomore, Junior or Senior) (string) AGE – age of the student (integer) DEPTID – identifier of the department the student is majoring at (string) This command should add a student with the given parameters to the database. Note that a department identified by DEPTID should already exist in the database to be able to add a student majoring in that department. Otherwise, you should print “Error: Department does not exist!”. Addition of duplicate SNUM is not allowed. In the case of attempting duplicate SNUM addition, your program should print “Error: Student already exists!”. add_faculty: FID – unique identifier for the faculty (string) FNAME – full name of the faculty (string) DEPTID – identifier of the department this faculty is affiliated with (string) This command should add a faculty with the given parameters to the database. Note that a department identified by DEPTID should already exist in the database to be able to add a faculty affiliated with that department. Otherwise, you should print “Error: Department does not exist!”. Addition of duplicate FID is not allowed. In the case of attempting duplicate FID addition, your program should print “Error: Faculty already exists!”. add_class: NAME – unique identifier for the class (string) ROOM – the classroom for this class (string) MEETS_AT – day and time this class meets at (string) FID – identifi...
View Full Document

Ask a homework question - tutors are online