Based on the requirements below, create a CRUD matrix that identifies the major database operations for each process/dat

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Based on the requirements below, create a CRUD matrix that identifies the major database operations for each process/dat

Post by answerhappygod »

Based on the requirements below, create a CRUD matrixthat identifies the major database operations for each process/datastore combination. Keep in mind that a CRUD matrix will include thefollowing:
processes labeled along the left-most vertical columndata stores labeled along the top most horizontal rowthe database operation(s) at the intersection of each process/datastore (Create, Read, Update, Delete)
Requirements:
The system shall allow students to request enrollment in acourseThe system shall allow the registrar’s office to input courses, butwill only create new records if the course doesn’t already exist inthe systemThe system shall allow the registrar’s office to input new studentrecords, but will only create new records if the student doesn’talready exist in the systemThe system shall send reports to the registrar’s office on courseenrollment dataThe system shall validate student enrollment requests againstcurrent course enrollments to not allow duplicate enrollment in thesame courseThe system shall enroll students in courses if they are not alreadyenrolledThe system shall return a success or error message to studentsbased on course enrollment transaction statusThe system shall store data about all active students, includingtheir unique student id, first name, last name, and emailaddressThe system shall store data about all courses, including the uniqueclass id, class subject, class number, and class nameThe system shall store student enrollment data, including studentid, class id, and enrollment date
Assumptions:
All students are active and eligible for enrollmentStudents are not required to enroll in any course, and courses arenot required to have any studentsStudents can only register for a course onceThere are no prerequisites for any courseThere is no enrollment capacity for each course
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply