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.

Reviews

Write a Review

 

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd