Question: c: Create a ERD describing the key data components for the selected scenario (50pts) For the ERD, include key entities/tables and data elements, identify relationships

c: Create a ERD describing the key data components for the selected scenario (50pts) For the ERD, include key entities/tables and data elements, identify relationships including primary keys, foreign keys, and cardinalities between tables.

Professor Checks which students signed up for course Indicates the courses they teach Add/drop course Change the schedule Requests course catalogue Course information Check the course availability Select courses for the semester Information about course availability Alternative courses Online registration system Student Check the number of seats available Course Update the available seats Amount payable for the courses Pays the fees Registration successful Sends the information about selected courses Total amount payable Credit the amount for dropped courses Billing system

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 General Management Questions!

=+4. Broccoli Pizza & Pasta, an Italian franchise brand, has set up its kitchen area based on the production planning and assembly line techniques to maximize efficiency, to create a wide range of...

Pizza (or other food) store, including ordering, cooking, delivering. Could include tables for: Customer, Orders, Products (menu items), Ingredients, Stores. Create a. Data Model create a Data Model...

Assignment brief Quiet Attic Films is a film production company based in London, England who specialize in making short information films and advertisements for television. They want you to design...

Quiet Attic Films is a film production company based in London, England who specializes in making short information films and advertisements for television. They want you to design and implement a...

Assignment brief Quiet Attic Films is a film production company based in London, England who specialize in making short information films and advertisements for television. They want you to design...

Assignment 1. You recognize that the existing table structure is very poor and need to improve it. Given what you see in the table above, a) Draw a dependency diagram. Identify the possible primary...

CSIS 325 Lab 4 (SQL CREATE TABLE) Before beginning this lab, be sure you have successfully downloaded and installed SQL Server Express 2014: (You should have already done this in your first lab, but...

A relational database must be designed and normalized before it can be created, populated with data, and used. Database design depends on the business scenario(s) a database architect needs to model,...

For this hands - on assignment, identify and describe the type of data for the database you are developing to design a relational database for your AI assistant. You will apply your knowledge of...

Quiet Attic Films is a film production company based in London, England who specialize in making short information films and advertisements for television. They want you to design and implement a...

Which of the following is true about the expected value of perfect information? a) It is the amount you would pay for any sample study. b) It is calculated as EMV minus EOL. c) It is calculated as...

(bor a fixed system that is independent of time &, show that the kinetic energy Tis a homogeneous quadratic function of the generalized veiocities dj nad obeys the Euler's Theorem forin = 2.

A company may carry back a tax loss for 4 1 of 5 5 years and carry forward a tax loss forThis test: 1 1 0 points ) possibleThis question: 2 points ) possiblyears.O A . 1 ; 1 5 B . 1 5 ; 1 c . 2 0 ; 2...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...