Draw ER diagram for the below scenario. Show entity names, primary keys, attributes for each entity, relationships between the entities and foreign key. It is required to keep the following
can you help me with the following ERD diagram question?
Draw ER diagram for the below scenario. Show entity names, primary keys, attributes for each entity, relationships between the entities and foreign key.
It is required to keep the following information on students, courses and sub-courses. Each student has a name, identification number, home address and a number of qualifications for which the subject (e.g. maths), grade (e.g. C) and level (e.g. `A' level) are recorded. Each student is registered for one course where each course has a name (e.g.
Each course is divided into sub-courses where a sub-course may be part of more than one course. Information on sub-courses includes the name, identification number and the number of students taking the course.
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)