Scenario:
You are a consultant assigned to work at the University Tong. You are to create an online Student Class Registration System.
The new Student Class Registration System needs to be in operation for the Spring 200X.
There are several factors you need to be aware of before you begin your work. The student can register for multiple courses at a time. The class score types are A, B, C, D and F; in which an F means a failing score. The student can access their score for any class in any semester. Students can withdraw from a class within 30 days after the semester begins. One instructor can teach several classes. The database user can retrieve information from the database by using the class ID, which is a unique number. Once the class ID is identified, the system can run a report to find a class during a certain semester. The University Tong's semesters are divided into Spring, Summer, and Fall. The current semester is Summer 2003. The class schedules have been created for the next two years.
You will need to collect the following :
• The degree program in which the student is registered. A student can register as an undergraduate, graduate or non-degree student. Graduate status is a Master and/ or PhD. program.
• Each class should have information such as instructor, location, duration, department, etc.
• An instructor is categorized as a Professor, Adjunct Professor, or Lecturer.
• All information on classes, students, department, and instructors can be added, deleted, and updated.
• When a student registers for classes, the student can choose the same class number, which can be offered by two instructors in a semester. This allows student to register for popular classes.
Ultimately, to create this Student Registration System, you will need to do the following:
• understand the Database Application Life Cycle
• understand the duties of a Database Administrator
• understand the newest technology used (such as case tools, UML, and OOD) in the creation of database systems.
• understand the intricacies of tables, relationships, integrity constraints, queries and reports of database systems.
Attachment:- Tables.zip