 Study Guide Unit 5, Section 3 


This assignment requires that you develop and submit the following items for selected aspects of the proposed Car Sharing IS:

1. A relational database schema based on the domain class model

2. Data access classes

3. Integrity Controls

4. Access security

 Text should be submitted in MS-Word (or Word-compatible) or PDF (or PDF compatible) format.

  Diagrams must be prepared using one of the software tools suggested in Unit 0.

If you would like to use another tool, you have to ask your tutor before you start with this assignment! 

 If the diagrams are small (smaller than one page) you may paste them into a Word or PDF file instead of submitting a .gif or .jpg file. Make sure the diagrams are readable!



1. Design a relational database schema from the Car Sharing IS domain class diagram by following the steps in “Designing Relational Databases,” “Evaluating Schema Quality,” and “Data Normalization” on pp. 376–386 of the textbook. The output should look like any of Table 12-6 to 12-9 on pp. 379–381 of the textbook.

2. Design the data access classes involved in the “Make Reservation through Web Interface” use case required to implement the bridge between data stored in program objects and in a relational database (see page 387 of the textbook).

You are not required to produce code to implement the data access class methods.

3. Provide your recommendations, with explanations, for application of each of the seven integrity controls. For input and output controls, focus only on the “Make Reservation through Web Interface.” See pp. 392–396.

4. Access security:

a. Describe the users for which the Car Sharing IS is designed and those for which it is possibly not designed (see pp. 397–399 of the textbook).

b. Prepare an access control list (see p. 397 of the textbook).

Part A is worth 80 marks. Marking criteria are completeness and correctness of

 relational DB schema (40 marks )

 data access classes (8 marks)

 integrity controls (24 marks)

 access security (8 marks)

Page 2 of 4


The organization and presentation of information are part of the interpersonal and

communication skills required of systems analysts.


Select one of the following distributed database architectures:

 replicated database server architecture

 partitioned database server architecture

 cloud-based database server architecture

Explain what advantages and disadvantages the selected architecture has, and give a concrete example for which situation the selected architecture would be the best choice and for which situation the selected architecture would not be a good choice. Provide proper justification for your reasoning and arguments. Answer the questions above, using overall 200–300 words. Being able to answer questions precisely is part of the interpersonal and communication skills required of systems analysts; therefore, meeting the word limit is important.

Answers consisting of more than 300 words will be marked with 0 points, and answers of less than 200 words will receive reduced marks proportionate to the length of the answer.

Make sure that your answer is written in your own words rather than being copied either from the textbook or from another source! Cite the sources you use in your answer, and provide references. There should be at least two references in your answer, and at least one of them should not be the textbook. If you are not sure how to list and cite sources, please read “How to Cite Correctly” in the Important

Resources block on the right side of the course home page.

Part B is worth 10 marks. Marking criteria are

 completeness and correctness (9 marks)

 presentation – readability, use of references, etc. (1 mark)

The organization and presentation of information are part of the interpersonal and communication skills required of systems analysts.


In this part of the assignment, you are asked to reflect on the activities that you have completed for Assignment 5. Use your blog to reflect on your problems, insights, and contributions during and after your task-related activities. For example, you could ask yourself the following questions: What was easy and what was difficult in this assignment? What causes/caused me problems (and why)?

Which  solutions or approaches have I found/tried that could also be useful for my colleagues? Where was I unable to find a solution (and why)? How do/did I approach the current problem? etc.

 Do not include any concrete, specific solutions from your assignment in your reflection message! The goal of this activity is to write and reflect from a generic point of view rather than discussing concrete solutions!

The minimum requirement for this assignment is one blog posting of at least of 300 words. You are, of course, encouraged to post longer messages as well as more often!

Post your message to your blog on and also upload a copy of your posting for Assignment 5.

Part C is worth 10 marks. Marking criteria are

 level of reflection (9 marks)

 presentation – readability, etc. (1 mark)
Powered by