Consider a hypothetical online management system for the Saudi Electronic University that uses a relational database to manage its operations. This system needs to keep track of information about students (including student ID, name, major, and email), courses (including course ID, name, instructor, and department), and enrollments (including enrollment ID, student ID, course ID, grade, and semester).
Avoid plagiarism
Requirements: 100-200
Question One
Consider a hypothetical online management system for the Saudi Electronic University that uses a relational database to manage its operations. This system needs to keep track of information about students (including student ID, name, major, and email), courses (including course ID, name, instructor, and department), and enrollments (including enrollment ID, student ID, course ID, grade, and semester).
Describe how you would design the relational model for this system. What tables would you create? What attributes would each table have? How would you use primary and foreign keys to represent relationships between the tables?
Answer:
Question Two
Consider a database system for SEU that stores information about students, courses, faculty, and course enrollments. A student has a unique ID, name, major, and email. Each course has a unique course ID, name, department, and credits. Faculty members have unique faculty IDs, names, departments, and specializations. An enrollment associates a student, a course, a faculty member (as the instructor), and a semester. One student can enroll in multiple courses, but each enrollment is for only one course. A faculty member can instruct many courses, and each course can have multiple students enrolled over different semesters.
Based on this description, create the ER diagram.
Answer:
Question Three
Define the Entity Integrity Constraint and Referential Integrity Constraint then explain their differences in a relational database. Explain why the DELETE operation may violate only the referential integrity and not the entity constraint. Provide examples to illustrate each constraint using the database system for SEU from question 1.
Answer:
Question Four
Using your own words, explain two advantages of the Three Tier Client-Server Architecture over the Single Tier Centralized DBMS Architecture.
Answer:
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.