Question
These are business rules for a sys below, please Draw an entityrelationship ER or an enhanced E(E)R schema accurately to represent set of business rules
These are business rules for a sys below, please Draw an entityrelationship ER or an enhanced E(E)R schema accurately to represent set of business rules requirements. You can use any tools to draw the E(E)R.
Business rule requirements of the system:
A user account authentication table with account activity recording:
- User must provide a valid account-password pair to login - Login attempts will be recorded to prevent unauthorized access. - Last successful login time will be recorded.
A course registration table with several capabilities:
- Students can view all available courses - Students can register for courses - Courses have per-section open seat limits - Enrolled courses must not overlap day and time availability - Courses can have prerequisites - Students cannot register for courses if their past enrolled courses do not meet requirements - Prerequisite courses must be complete with a grade C or higher to authenticate a successful registered course - A course could have multiple sections - Student can only register to one section per course
A grade viewer table: - Students can view their past registered courses that show details such as term and grade - Students could view a past or current term and its associated courses - An individual course record will indicate a percentage for calculating an average GPA and a static average grade - Collectively, this information will format a transcript table
Faculty/Professor tables to include:
- Can assign grades to current student of their section - Can view past or current enrolled students of their specific courses - Can view multiple enrolled courses and their associated section - Can add or drop students from the sections
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started