Q1: Suppose that your uncle is a real estate agent and he decided to have a web-site to list his available real estate properties. And use a laptop computer to show clients these properties. What hardware is needed to have a web-site and client to browse the properties on that web-site? How many (n-tired) computers are needed for this system? List at least one advantage for this new system?
Q2: What are three main steps associated with building the (ERD), list these three steps?
Explain how do you represent, 1-to-1 (1:1), and 1-to-many relationship (1:N) and many-to-many relationship (M:N) ?
Q3: Case Study: describe using ERD diagram how the university can manage Building, Classroom, Course, students, and Instructors, each of which is a table that is drawn indicating Primary Key, and Foreign key. Then explains how the university can add a new course without conflicting with others courses' time and classroom.
Notice: the relation between Course and Student is m-to-m because a Student may have more than one Course has more than one student.
Draw the ED-D using crows-feet notation. Show the entities and relationships between entities (Building, Classroom, Course, student, Instructor). Indicate the PK primary key, and FK foreign key in each table)