Test 3

Question 1

First normal form

Answer 1

Each value must be scalar and no repeating columns

Question 2

2nd normal form

Answer 2

Every non key column must depend on the primary key

Question 3

3rd normal form

Answer 3

every non key column must depend only on the primary key. (considered good design)

Question 4

What would violate referential integrity.

Answer 4

Deleting a row from a primary key table, inserting a row into a foreign key, update value of foreign key, update value of primary key or foreign key

Question 5

Ch 8 datatypes, what datatypes will store whole numbers, character.

Answer 5

Integer-whole numbers. Decimal- decimal numbers. Char-fixed string length. Varchar-max string length.. Datetime-exact date(millisecond). smalldatetime-date (minute). Date-date

Question 6

Relationships one to one, one to many, many to many.

Answer 6

One to many is most common

Question 7

What is used after Create database

Answer 7

Go

Question 8

What is a constraint?

Answer 8

A way to filter what data goes through.

(inline) InvoiceTotal MONEY NOT NULL CHECK(InvoiceTotal >= 0)

(bottom) CHECK (InvoiceTotal >= 0)

Question 9

Keyword for constraint on a column?

Answer 9

Check keyword

Question 10

Customer order has to refer to Customer, what do you use?

Answer 10

A join/ foreign key

A referenced table must be made before a table can reference it.

Question 11

Where do records come from?

Answer 11

tables

Question 12

When planning the database, 100 east main street sc how do separate.

Answer 12

Street name, city, state, number

Question 13

What do CAST and CONVERT do?

Answer 13

Cast changes one data type to another. Convert does the same thing but more complex.

Question 14

Date function

Answer 14

GETDATE()

Question 15

Unicode character

Answer 15

Nchar-fixed unicode length. Nvarchar-max unicode length

Question 16

What is index?

Answer 16

makes a sql statement that you can use repeatedly. Create (index name)

Question 17

A good reason to not make an index?

Answer 17

If the column you make an index on will be constantly changing.

Question 18

What is foreign key?

Answer 18

When a primary key is referenced.

Question 19

decimal(6,2) What does this mean?

Answer 19

6 is how many numbers can be put in (6). 2 is how many decimal places .00

Question 20

What is ddl?

Answer 20

Data definition language, defining the structure of the tables. Create database and tables, constraints

Question 21

Action queries?

Answer 21

Select, insert, commands that change records.

Question 22

Identity key?

Answer 22

Sets its own values, you don’t need to input data. Useful for primary key ids

Question 23

What do primary keys combined together make?

Answer 23

Composite key, this is called a linking table.