Reference no: EM13944190
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
|
Expansion capability of an existing australian company
: The purpose of this assignment is to analyse the expansion capability of an existing Australian company, PETSTOCK
|
|
Diameter of the hole and the diameter of the bolt
: Determine the standard deviation of the difference between the diameter of the hole and the diameter of the bolt. (Round your answer to 4 decimal places.)
|
|
How might we characterize the true self
: Philosophically, is God Identical to Brahman?:- Given the many attributes that are said to belong to Brahman, could the Judeo-Christian/Islamic notion of God allow it to be considered identical to God? Similar? Why or why not?
|
|
What are the differences between gross income and agi
: What are the differences between the following components of taxable income? Provide at least one example of each. Deductions for AGI and deductions from AGI. Gross income and AGI.
|
|
Create an online student class registration system.
: All information on classes, students, department, and instructors can be added, deleted, and updated.
|
|
Removed from the outlet sugar to dry
: If 1000 tons/day of wet sugar is fed to the evaporator, how much additional water must be removed from the outlet sugar to dry it completely, and what annual revenue can be expected if dry sugar sells for $0.15/lbm?
|
|
Using the same manufactured goods category
: Using the same manufactured goods category, forecast what products in your category will be replace with innovative products and latest segment. Present a motivation for your preference.
|
|
What challenges to change occurred
: After reading the assigned HBS article on change, please think about a personal experience you have had related to organizational change. What challenges to change occurred? What could organizational leaders and decision makers have done to make the..
|
|
How do you personally use language to create reality
: How do you personally use language to create reality? There is an oft repeated adage, "When you learn another language, you gain another soul." What do you think this means?
|