3 small questions in Data Base

[Total Mark for this Assignment is #5]

Fundamentals of Databases

IT403

Question One

2 Marks

Suppose you want to store the following information:

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 Marks

2. Using the following relations to 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

1 Mark

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?