MIS Park University Data Models for Registration and Billing Processes Discussion
ANSWER
User Listing:
First Name Last Name User ID
The email address
Username hashed and salted password
role (e.g., instructor, admin, or student)
Contact Details (number and address)
Status of the registration date (active, pending, suspended)
Details of the Course:
Course ID, Name, Description, and Instructor(s)
Date of Start; Date of End; Maximum Capacity
Actual Enrollments
Course Status (finalized, in progress, or on schedule)
Details on Enrollment:
ID of Enrollment
User ID for pupils
Enrollment date, course ID, and status (enrolled, completed, dropped)
grades, if relevant
Payment and Invoicing:
Transaction Number
Payer’s User ID
Date of Payment Method (PayPal, credit card, etc.)
Amount of Payment Details of the Invoice/Receipt
The status of payments (pending, processed, failed)
Management of the instructor and course:
ID courses for instructors Course Materials (files, links) that were taught
Information about Grading (Assignments, Exams, Grades)
Data Administration:
Admin Roles, Admin ID, and System Logs (audit trail)
Logs of User Activity
Security Permits Security Information:
ACLs (Access Control Lists) to safeguard data
Keys to Encryption
Tokens for Authentication
Security Guidelines
Data for Communication:
Notes and Communications
History of Communication (sent emails, sent notifications)
Analytics and Reports:
Usage Metrics: Course Access, User Activity
Financial Statements (income, costs)
Reports on Enrollments
Surveys and Reactions:
Response Surveys
Reactions to Surveys
Enhancement Suggestions
Assistance & Help Desk:
Details of Support Tickets Issues
Status of the ticket (open, closed, in process)
Resource Administration:
Course materials: papers, recordings, and tests
The ID of the resource
Type of Resource: Document, Video, Quiz
Synopsis of the Resource
Availability of Resources (public, restricted, private)
To guarantee data integrity, confidentiality, and availability, consider previous architecture and security considerations when creating these data structures. To ensure data security, put in place the appropriate audit logs, encryption, and access controls. To maximize database speed, ensure data is normalized and create relationships between data structures as needed.
QUESTION
Description
Business Data Architecture/ Data Models
Any IS system operates with data. Data can have different types. Review the course resources to ensure a thorough understanding of data and the unique types.
Directions
Design data structures (variables, lists, objects) that will describe the registration and billing processes of your Course project.
List the data structures IS will need to have in order to support those processes.
For example, one of the structures should describe a list of registered users with their statuses and other parameters, that you will find important.
Consider the past architecture and security details as each can uniquely impact your approach.
Fill in the order form and submit all your files, including instructions, rubrics, and other information given to you by your instructor.
Once you complete filling the forms, complete your payment. We will get the order and assign it to a writer.
When your order is completed, it’s assigned to an editor for approval. The editor approves the order.
Once approved, we will upload the order to your account for you to download. You can rate your writer or give your customer review.
