x projectcasestudy.pdf x View Group Task - 224la kku.edu.sa/webapps/blackuoard/execute/tasw course_id%3 22879 1&task_id3 301 1&from%3Dgroup_tasks&filter=&igroup_id%3D 3208_1 A Group-1 Group -1 Project Task Scenario-1 In a university/college, a student called class representative (CR) represents other students of his class. The "STUDENT" entity may have attributes like University-ID, Name, and Phone Number etc. Let us draw an E-R Diagram of this case. Scenario-2 A student in a university takes one or more courses according to his choice. But in order to be a student, he must take at least one course. The course may have one attributes like Course-ID, Course-Name and Course-Fee etc. Draw ER diagram to show the relationship between "Student" and "Course" Scenario-3 A course is always thought by some course teacher. A teacher cannot exist without corresponding course. A course may be thought by at least one or more teacher. On the other hand, a teacher may teach at least one or more course. Scenario-4 Each department has a HOD/chairman while chairman chairs only one department. Show the relationship. Chairman is a week entity because its existence is dependent on corresponding department. The relationship can be read as: "A department has a chairman" or "A chairman may have a department". Scenario-5 A teacher belongs to only one and only one department. However, a department may have at least one or more teachers. The teacher can be visiting, part-time, or full-time. The relationship between "Teacher" and "Department" can be read as: "A teacher belongs to one or only one department" or "A department may have one or more teacher" Question: Complete ER model for university system to combine all 1,2,3,4 and 5 case scenarios Sunday, April 19, 2020 Normal Part 2-1 Overveiw.pptx Part 2-2 Data Pre..pptx Part 2-1 Overveiw. cull lis isI
x projectcasestudy.pdf x View Group Task - 224la kku.edu.sa/webapps/blackuoard/execute/tasw course_id%3 22879 1&task_id3 301 1&from%3Dgroup_tasks&filter=&igroup_id%3D 3208_1 A Group-1 Group -1 Project Task Scenario-1 In a university/college, a student called class representative (CR) represents other students of his class. The "STUDENT" entity may have attributes like University-ID, Name, and Phone Number etc. Let us draw an E-R Diagram of this case. Scenario-2 A student in a university takes one or more courses according to his choice. But in order to be a student, he must take at least one course. The course may have one attributes like Course-ID, Course-Name and Course-Fee etc. Draw ER diagram to show the relationship between "Student" and "Course" Scenario-3 A course is always thought by some course teacher. A teacher cannot exist without corresponding course. A course may be thought by at least one or more teacher. On the other hand, a teacher may teach at least one or more course. Scenario-4 Each department has a HOD/chairman while chairman chairs only one department. Show the relationship. Chairman is a week entity because its existence is dependent on corresponding department. The relationship can be read as: "A department has a chairman" or "A chairman may have a department". Scenario-5 A teacher belongs to only one and only one department. However, a department may have at least one or more teachers. The teacher can be visiting, part-time, or full-time. The relationship between "Teacher" and "Department" can be read as: "A teacher belongs to one or only one department" or "A department may have one or more teacher" Question: Complete ER model for university system to combine all 1,2,3,4 and 5 case scenarios Sunday, April 19, 2020 Normal Part 2-1 Overveiw.pptx Part 2-2 Data Pre..pptx Part 2-1 Overveiw. cull lis isI
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
100%
question: complete Er model for university system to combine all 1,2,3,4and 5 scenario .
5 scenario attached in the picture
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education