THE COURSE IS IT 243 SYSTEM ANALYSIS

Learning Outcome(s):

Chapt.(7) Three design strategies

Question One

List the three design strategies, and give at least 2 advantages and 2 disadvantages of each.

5 Marks

Learning Outcome(s):

Chap. (8) Architecture Design: Understand the difference between fat and thin clients

Question Two

Differentiate between fat and thin clients. (3 points)

State two advantages of using thin clients over fat clients. (2 points)

5 Marks

Learning Outcome(s):

Chap. (8) Architecture Design: Understand the pros and cons of n-tiered architecture

Question Three

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?

5 Marks

Learning Outcome(s):

Chapt. (9)User Interface Design

Question Four

Discuss the major principles for User Interface Design?

5 Marks

Learning Outcome(s):

Ch. (6)

Understand and being able to build ERD.

Question Five

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) ?

10 Marks

Learning Outcome(s):

Ch. (6)

Building ERD

Question Six

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)