Reference no: EM132961544
CSI6207 Systems Analysis and Database Design - Edith Cowan University
Part 1
1. Give three examples (not from the tutorials or lecture slides) of Functional requirements.
2. Give three examples (not from the tutorials or lecture slides) of Non-functional requirements.
3. Describe some of the major differences between User stories and Use cases.
4. What is an "Acceptance Criteria" in the context of a user story?
5. Give three examples of an appropriate use of the generalisation relationship in a use case diagram.
6. In your own words, describe what the <<includes>> relationship is used for in a use case diagram.
7. Which kind of relationship is allowed between actors in a use case diagram?
8. What is the purpose of the horizontal synchronization bar in an activity diagram?
9. What do activity diagrams model?
10. Describe the six stages of the SDLC and their purposes.
Part 2
1. What is an "attribute" of an object? List 3 possible attributes of a "Vehicle" object.
2. What is "Cardinality" or "Multiplicity" in object relationships and why is it important?
3. Describe the difference between an "Aggregation" relationship and a "Composition" relationship in a UML class diagram.
4. Give three examples of objects that could inherit from a superclass.
5. Why are many to many cardinalities allowed in a UML class diagram but not in an entity relationship diagram?
6. What is a state machine?
7. What is a foreign key used for? Give an example of a foreign key and how it could be used.
8. Is it necessary to include primary keys in an object? Why/why not?
9. Is it necessary to include primary keys in an entity? Why/why not?
10. Name five entities that might appear in the ECU Blackboard system.
Part 3
1. What is an "attribute" of an object? List 3 possible attributes of a "Vehicle" object.
2. What is a good use for a compound key?
3. Normalise the following data attributes into 3nf report_title, report_date, first_name, last_name, phone_number, {subject_code, subject_name, mark_percentage, grade}
4. Write an SQL query that would return the first and last names of each user in a "users" table that have the password "12345"
5. Write an SQL query to create the following table:
|
purchase_id
|
quantity
|
product_id
|
customer_id
|
|
|
|
|
|
|
|
|
|
|
Where two other tables exist (Product and Customer).
Include appropriate constraints. (quantity must be greater than 0)
6. What is DDL and what is it used for?
7. Why would you use the DISTINCT keyword? Give an example of its use.
8. What are the different character/string based datatypes and why are they different?
9. Describe what the following LIKE pattern would be capable of matching: ‘_a[m-p][q-t]_%'
10. What does the "IS" keyword do and how is it different from "="?
Attachment:- Quizzes.rar