Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a Design Specification Document ( DSD ) for an Exam Registration System. The CIT department at CSN will use the Exam Registration System. Students

Create a Design Specification Document (DSD) for an Exam Registration System. The CIT department at CSN will use the Exam Registration System. Students will use the system to register for Certification exams. Develop a Data Dictionary that defines all data elements used within the system. Include each data element's data type, length, format, and description. Design the database schema for the Exam Registration System. This should include entity-relationship diagrams (ERD), tables, fields, relationships, and any constraints necessary to accurately represent the system's data model.These are the requirements: Building exam registration system= using caspiotool, 100 people for registration, I need the faculty members at csn to be able to set up their exams within the system, there are 3 exams. building the system to allow students to sign up for their exams. The timeframe is 7 weeks. Need to verify that the student goes to the school with authentication. Username should be email address password should be password. No system in place. No payment for exam. No budget for exam. Once we are logged in, show the available exams. Need to have the student select location, then the exam, date. All this with a calendar. Then select the time. Button to register. Confirmation email. Have a template for the confirmation emails. Once they are logged in and authenticated, they do not need to input any additional information. Faculty needs will see all the names and exams, add exams. A requirement is to cancel the exams you need to cancel. Max seating is 20, so 60 each. Once it is full you want to hide the full exams. If someone cancels the exam will pop up for the next person. For the faculty side you would like to view the exams by viewing criteria. A faculty member can cancel then the exam then the students will be verified. There should be a search function so they can see how many exams they are registered. System should prevent duplicate log in. Shouldnt be able to book the exam twice. Like no duplicate booking. No overlapping time slots. Faculty would like a report. A list of student, location, date, exam, teacher to generate report.

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

Successful Keyword Searching Initiating Research On Popular Topics Using Electronic Databases

Authors: Randall MacDonald, Susan MacDonald

1st Edition

0313306761, 978-0313306761

More Books

Students also viewed these Databases questions

Question

What is a break-even point?

Answered: 1 week ago

Question

1. How will you, as city manager, handle these requests?

Answered: 1 week ago