Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following details of a course registration system: This case is a logical description of the desired application. Your task is to analyze and

Consider the following details of a course registration system:

This case is a logical description of the desired application. Your task is to analyze and design the data and processes to develop an automated application to perform course registration. A student completes a registration request form and mails or delivers it to the registrar's office. A clerk enters the request into the system. First, the Accounts Receivable subsystem is checked to ensure that no fees are owed from the previous quarter. Next, for each course, the student transcript is checked to ensure that the course prerequisites are completed. Then, class position availability is checked; If all checks are successful, the student's social security number is added to the class list. The acknowledgment back to the student shows the result of registration processing as follows: If fees are owing, a bill is sent to the student; no registration is done and the acknowledgment contains the amount due. If prerequisites for a course are not filled, the acknowledgment lists prerequisites not met and that course is not registered. If the class is full, the student acknowledgment is marked with 'course closed.' If a student is accepted into a class, the day, time, and room are printed next to the course number. Total tuition owed is computed and printed on the acknowledgment. Student fee information is interfaced to the Accounts Receivable subsystem. Course enrollment reports are prepared for the instructors.

a) Perform a structured analysis of the system and describe the steps

b) Create a context diagram by defining the boundaries for the application

c) Create a data flow diagram (DFD) and balance it with the context diagram

d) Create a data dictionary and enter the names and definitions of all the entities

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

AWS Certified Database Study Guide Specialty DBS-C01 Exam

Authors: Matheus Arrais, Rene Martinez Bravet, Leonardo Ciccone, Angie Nobre Cocharero, Erika Kurauchi, Hugo Rozestraten

1st Edition

1119778956, 978-1119778950

More Books

Students also viewed these Databases questions

Question

Appreciate the rationale for having a human resources department.

Answered: 1 week ago

Question

What are some global employee and labor relations problems?

Answered: 1 week ago