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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!