Reference no: EM132961547
CSI6207 Systems Analysis and Database Design - Edith Cowan University
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:- Quiz 3.rar