DBST 651 United Medical And Dental College Data Models Discussion

Description

Read and contribute/comment on peer discussions.

Peer 1:

Question 1

Attached functional requirement document

Question 2

Relational data model or entity relationship diagram are important because it defines how data should flow and operate in a database. With a well defined data model, data functionality can be optimized and efficient. It also defines how data should communicate with each other through relationships which helps define data flow.

Question 3

Attached ERD screenshot

Week2q1.docx(11.83 KB)
ERD.PNG(35.83 KB)
Peer 2
You have been hired as a consultant by UMGC to help with their student information system. I would like you to login to my.umgc.edu and choose one of the functionalities (enrollment/registration, payment, etc) of your choice, then write a simple business document not exceeding ONE page. This document is called the functional requirements or business requirements which will be given to the technical staff/consultants who will translate the requirements into data model and create tables in the database using SQL. Please try to make it simple and just cover essential features.Enrollment/Registration
1. Purpose of Document
2. This is a Requirements Specification Document for an enrollment/registration system for University of Maryland Global Campus (UMGC). The system will provide students the ability to search and enroll for classes online. This document outlines the functional requirements, scope, and objectives.
3. Scope of Project
4. The scope of this project is a web-based system that allows UMGC students to search for and enroll in available courses. Account billing is not a part of this project.
5. Functional Requirements
- The system must allow users to generate a report (Academic Advisement Report) to determine which requirements they have left to fulfill
- The system must require users to select a semester when searching for classes
- The system must allow users to search for classes by subject
- The system must allow users to search for classes by location
- The system must allow users to search for classes by course number
- The system must allow users the option to search for classes with open seats only
- The system must allow users to register for up to 6 credits per semester
- The system must allow users to view the number of available seats for courses
- Based upon the functional document created in #1, describe the importance of relational data model or entity relationship model.A relational data model plays an important role in the system creation process. A relational data model is also referred to as a blueprint because it helps to visually represent what is needed for a functional system (Gonzalez, 2022). Based on the functional document included above, the relational data model would be created to represent all the functional requirements and their complexities. This document would be used to ensure that the information is properly understood so that the functional system can be created successfully. Create an ERD using ER Assistant or Oracle Data Modeler for the chosen functionality in #1.

Our Service Charter

1. Professional & Expert Writers: Writers Hero only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Writers Hero are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Writers Hero is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Writers hero, we have put in place a team of experts who answer to all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.