Retrieve data of students from past and current enrollment

Assignment Help Database Management System

Reference no: EM132083516

Norwoods University has decided to replace its aging mainframe-based student registration system with a more modern client/server database system.

School officials want provide students with the capability to retrieve course availability information, register for courses, and print transcripts using personal computers located in the student computer labs.

In addition, faculty members must be able to retrieve students course lists, drop and add students, and record for the students they advice. Security is a prime concern, so students and course records must be protected by password access.

Students will log onto Norwoods system using their student Id and PIN. They will be given the option of viewing current course listing or viewing information on courses they have completed. They can check what courses are available during the current term by viewing course information, such as course names, course ID, section numbers, days, time, location; and the availability of the open seats in the course.

They can also view information about courses they have taken in the past as well as grades and GPAs. Faculty members will log onto system using faculty ID.

They can select from the list of courses they are teaching in the current term and retrieve a list of students enrolled in the selected course.

Faculty members can also retrieve list of his or her advisees. Select one, and then retrieve that student's past and current enrollment information.

The data items for the Norwood database include:

Student name, address, phone, class (freshman, sophomore, junior senior, etc), date of birth, PIN number, and advisor ID Course call number, name, credits, maximum enrollment, instructor, and term offered Instructor name, office location, phone number, and rank Student enrollment and grade information

Reference no: EM132083516

Questions Cloud

Instance of civil disobedience in the united states : What and when was the first instance of civil disobedience in the United States?

Prompt the user to input a food item name : Prompt the user to input a food item name, price, and quantity. Output an itemized receipt.

How much would absorption costing income : How much would absorption costing income from operations differ between a plan to produce 3,500 units and a plan to produce 5,700 units

Compute the gross profit rate : Prepare a multiple-step income statement - Compute the gross profit rate. (Round answer to 2 decimal places, e.g. 10.50.)

Retrieve data of students from past and current enrollment : Faculty members can also retrieve list of his or her advisees. Select one, and then retrieve that student's past and current enrollment information.

Reserve requirements on time deposits : What would be the estimated Eurodollar deposit rate if the domestic U.S. dollar deposit rate is 8½%, the reserve requirements on time deposits

Journalize each of the transactions : Depreciation on buildings is computed by the straight-line method. Please journalize each of the transactions from Jan 2nd - Dec 31st

Compute the activity variance for these data : Compute the activity variance for these data. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None"

Draw an erd for the database : Professors and GTAs are assigned to teach the sections of each class being offered in a semester.

User Account

All Pages