CS270 Winter 2004, Assignment #3

Due: March 23, 2004 in class

1. Draw a process model (just the processes, data stores, and data flows) for the following CRUD matrix. (22 marks)

2. What are the main activities that happen during the Design Phase of the SDLC? (5 marks)

2. What are the differences between the logical and physical ERD? (2 marks)

2. What are some system-related decisions that may result in a change to the physical DFD or ERD? (2 marks)

2. What are the differences between the time and arrangements, fixed-price, and value-added contracts for outsourcing? (3 marks)

2. What are the four general functions of any application? (4 marks)

2. What are the three main hardware components of a system? (3 marks)

2. Is client-server a less expensive alternative than server-based? Why or why not? (2 marks)

2. Describe the differences among two-tiered, three-tiered, and n-tiered computing. (3 marks)

2. Define scalable. Why is this term important to system developers? (2 marks)

2. Describe the major nonfunctional requirements and how they influence architecture design. (4 marks)

2. Explain the distinction between the three fundamental parts of the user interface. (3 marks)

2. Discuss ways in which the level of user experience affects user’s interface design. (2 marks)

14. New Concept Video Store is creating a relational database to store the information about customers and videos rented from their store. They have hired you to help them design their database (and they REALLY need your help!). The following data entity, and entity attributes describe the information they are interested in tracking:

(Note: Currently, customers can rent a maximum of 4 movies at a time)

The asterisks indicate identifiers.

Video_customer_table

*invoice_number billing_amount billing_date payment_received amount_paid customer_id customer_name customer_address customer_city customer_postal_code customer_phone_number customer_email *movie_barcode_number movie_in_stock date_received_from_vendor number_of_copies *movie_title_rented1 movie_barcode_numb_rented1 date_of_rental1 date_of_return1 *movie_title_rented2 movie_barcode_numb_rented2 date_of_rental2 date_of_return2 *movie_title_rented3 movie_barcode_numb_rented3 date_of_rental3 date_of_return3 *movie_title_rented4 movie_barcode_numb_rented4 date_of_rental4 date_of_return4

1. State the rule that is applied to place an entity in first normal form. Revise the above data model so that it is in first normal form. (6 marks)

2. State the rule that is applied to place an entity in second normal form. Revise the data model you created in a. (if necessary) to place it into second normal form. (6 marks)

3. State the rule that is applied to place an entity in third normal form. Revise the data model you created in b. to place it into third normal form. (6 marks)

75 total marks