Fineuhl

Question 1

How does a database reach first normal form?

Answer 1

Each value must be scalar ( returns one value and there should be no repeating columns

Question 2

How does a database reach 2nd normal form?

Answer 2

Every non key column must depend on the primary key

Question 3

How does a database reach 3rd normal form?

Answer 3

1st and 2nd normal form must be met and all columns must refer to the primary key.

Question 4

How do you enforce Referential integrity in the database.

Answer 4

Use declarative referential integrity or defining triggers.

Question 5

What would violate referential integrity.

Answer 5

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

Question 6

what datatypes will store whole numbers, character

Answer 6

Integer-whole numbers. Decimal- decimal numbers.
Char-fixed string length. Varchar-max string length..

Question 7

What relationship is most common.

One to one, one to many, many to many

Answer 7

One to many is the most common

Question 8

What is used after Create database?

Answer 8

Go

Question 9

What is a constraint?

Answer 9

A way to filter what data goes through.

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

(bottom)
CHECK (InvoiceTotal >= 0)

Question 10

Keyword for constraint on a column?

Answer 10

Check keyword

Question 11

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

Answer 11

A join/ foreign key

Question 12

When referencing a table when making a database you must do what?

Answer 12

Create the referenced table before it is referenced.

Question 13

Where do records come from?

Answer 13

tables

Question 14

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

Answer 14

Street name, city, state, number

Question 15

What do the CAST and CONVERT function do?

Answer 15

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

Question 16

Uses for the DATE function?

Answer 16

Datetime-exact date(millisecond). smalldatetime-date (minute).
Date-date

Question 17

Unicode characters

Answer 17

Nchar-fixed unicode length.
Nvarchar-max unicode length

Question 18

What is index?

Answer 18

Create index, makes a sql statement that you can use repeatedly.

Question 19

A good reason to not make an index?

Answer 19

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

Question 20

What is a foreign key?

Answer 20

When a primary key is referenced.

Question 21

What does this do decimal(6,2)

Answer 21

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

Question 22

Action queries?

Answer 22

Select, insert, commands that change records.

Question 23

What is ddl?

Answer 23

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

Question 24

Identity key?

Answer 24

Sets its own values, you don’t need to input data. Useful for primary key ids, must be the int datatype.

Question 25

What is a composite key?

Answer 25

Two primary keys together make a composite key. This is called a linking table.