Assignment
Question One
Suppose you want to store the following information:
|
Student_id
|
Course
|
Mark
|
|
111
|
Maths
|
78
|
|
111
|
Physics
|
90
|
|
222
|
Biology
|
89
|
|
333
|
Physics
|
60
|
|
333
|
Chemistry
|
75
|
1.a Is this table in first normal form? Why or Why Not?
1.b Why it is not in 2NF? How you can change the above table into 2NF.
Question Two
2. Using the following relationsto write SQL statement that follows:
Product (product_name, price, category, company_name)
Company (company_name, stockPrice, country)
a- Find all products produced by USA and have a price greater than 500.
b- Find the Categories that a product might belong to. Make sure that the category is not repeated and it is listed in ascending order.
c- delete all products with that belong to SONY company.
Question Three
3.a List the three design goals for relational databases, and explain why each is desirable.
3.b What is the result of an arithmetic expression involving nulls, for instance, what 7 + null would return?