Databases

Question 1

What is normalistaion?

Answer 1

Every non key attribute is dependent on the key, the whole key, and nothing but the key

Question 2

What is 1st normal form?

Answer 2

No repeated attributes

Question 3

What is 2nd normal form?

Answer 3

All attributes are dependent on the key

Question 4

What is 3rd normal form?

Answer 4

No attribute must be dependent on any non key attribute

Question 5

Describe the SELECT function in SQL

Answer 5

SELECT
FROM
WHERE
ORDER BY

Question 6

Describe the INSERT function in DML

Answer 6

INSERT INTO table_name (column1, column2…)

VALUES (value1, value2)

Question 7

Describe the UPDATE function in DML

Answer 7

UPDATE table_name
SET coulmn1 = value, column2 = value2….
WHERE some_column = some_value

Question 8

Describe the DELETE function in DML

Answer 8

DELETE FROM table_name

WHERE some_column = some_value

Question 9

a) Describe the CREATE TABLE function in DDL

b) What are some datatypes that can be used in table creation?

Answer 9

CREATE TABLE 
(
field name 1   (datatype),
field name 2   (datatype),
field name 3   (datatype),
PRIMARY KEY (field name)
)

Varchar(x), int, yes/no, date, money