Allows users to view and register for classes offered

Assignment Help Database Management System
Reference no: EM13718102

Message :

I need DFD done in Visio for: 
1 Context Diagram 
2 Level 0 Diagram 
3 Level 1 Diagrams 
Functional Requirements 
4.1 User Login / Registration 

Overview - Users will be able to register in order to use the system. If the user is register they will be prompted to enter their username and password to navigate through the system. 

Detail - Users of the system must register to use the system by providing personal information. Usernames and passwords will be generated by the system. If the user is already registered they will be prompted to enter their user name and password to gain access. First time users will be prompted to create a new account and an input information form will be displayed that must be completed prior to access. After login verification is complete, the user will be able to update their user account information and have full access to the system. 

4.2 Class Registration 

Overview- Allows users to view and register for classes offered. 

Detail- User will be able to view all classes offered for the current semester. After user selects classes, the system will prevent the user to select two courses offered at the same time. The courses will be added to student''s schedule and the student's semester bill.

4.3 Tutoring 

Overview- User will be able to schedule tutoring time to help them with the coarse workload. 

Detail - User will be able to select subject and tutoring time. The user will schedule time and show up according to the schedule. If the time selected is unavailable, user will need to re-select different time to schedule tutoring session.

4.4 Parking Permit 

Overview- Student will be able to get the parking permit. 

Detail- Student will be able to get the parking permit in order to park on campus. The student will have option to purchase two types of permits: permit for the whole year or permit for the semester. After selecting the choice student will input their vehicle information. Student will be able to pay for the permit by Credit card or a bank account. The permit can be mailed to the student, or it can be picked up at the security office at the campus by the student. Student ID is required in order to pick up parking permit.

4.5 Course and Faculty Evaluation 

Overview- User will be able to submit Survey and Give feedback about Course and Instructor. 

Detail - User may take a survey and give her/his feedback about the course and instructors quality. User will have separate box to note anything else not mentioned in the survey questionnaire. User will be able to save the progress and come back and finish it at different time. The use r will only be able to give feedback for the courses taken during the current semester.

4.6 Bookstore 

Overview- User may order books or any other school related material that is offered in the bookstore. 

Detail - User may order books and any other school related materials from the bookstore. The user has option to have items shipped with additional shipping fee, or the user may pick up all the items at the store. User will get the email confirmation when all items are all ready for pick up or shipping confirmation email with tracking number if shipping option is selected. 

Verified Expert

Reference no: EM13718102

List all the functional dependencies present in the relation

You must implement the entity relationship model provided in the model solution to Assignment 1. The model solution will be released on the course website approximately TWO

Calculate the total adults and children visitors

YOF EWS07 H1- In cells B11:E11, Create formulas in the cell range D6:E10. Calculate the total adults and children visitors as well as the adult and child admission collected.

Concept of entity in a process

Question 1: Use an example to explain what is an entity in a process? What is an attribute? Question 2: Define a measure that can be used to judge a code's quality. Name one s

Each member in the club is assigned a number

Expand the database design you created in Question #1 so that it will also support the following situation: Ray wants to start a DVD rental program at his stores. He refers to

Draw entity relationship diagram of state tennessee tn

Draw Entity Relationship Diagram (ERD) of state Tennessee TN. You could also list, for example, top five hospitals, or the bottom five percent. Set "Top Values" property on

Explain how to derive new classes from base classes

Explain how to derive New Classes from Base Classes. Describe classes, including constructors, methods, data, value, and reference types. Provide examples and uses in VB & C#

What was the total value of the disputed order

Write SQL SELECT statements to retrieve the following information from the ClassicModels database - select the product name, scale, vendor and product code for all models of

Write the functional dependencies in the table

Write the functional dependencies in the table which concerns invoicing (an application Premiere Products is considering adding to its database), subject to the specified co

Reviews

Write a Review

 
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