Test 2 Notes

Question 1

When converting an entity diagram into a relational schema, rule 1 states that….

Answer 1

Every entity is converted into a table.

Question 2

When converting an entity diagram into a relational schema, rule 2 states that….

Answer 2

All relationships are represented by placing foreign keys into tables.

Question 3

In the tables the identifiers become…….. and the attributes become ……..

Answer 3

1. Primary Keys
2. Columns

Question 4

In a 1:1 relationship where do you place the foreign key?

Answer 4

The foreign Key can be placed in one table or the other.

Question 5

In a 1:N relationship where do you place the foreign key?

Answer 5

The foreign key must be placed into the N(Child) side of the relationship.

Question 6

When converting a N:M relationship what must you do?

Answer 6

You must make a new intersection table.

Question 7

In SQL the CREATE key does what?

Answer 7

Creates objects.

Question 8

In SQL the ALTER key does what?

Answer 8

Modifies objects.

Question 9

In SQL the DROP key does what?

Answer 9

Deletes objects.

Question 10

In SQL the TRUNCATE key does what?

Answer 10

Deletes table data.

Question 11

In SQL the INT key holds what?

Answer 11

Whole Numbers.

Question 12

In SQL the VARChar() key holds what?

Answer 12

Strings

Question 13

In SQL the CONSTRAINT key does what?

Answer 13

Adds attributes, and creates composite, foreign, and primary keys.

Question 14

In SQL the INSERT key does what?

Answer 14

Adds new data

Question 15

Which Element follows after the SELECT keyword?

Answer 15

Column

Question 16

Which Element follows after the FROM keyword?

Answer 16

Tables

Question 17

Which Element follows after the WHERE keyword?

Answer 17

Criteria/Filter

Question 18

Which symbol in SQL shows all of the column values or items?

Answer 18

The asterisk (*) symbol.

Question 19

What SQL key cuts off output?

Answer 19

LIMIT

Question 20

What SQL key duplicates elements?

Answer 20

DISTINCT

Question 21

What SQL key carries DELETE or UPDATE actions on the primary key to matching foreign keys?

Answer 21

CASCADE

Question 22

What symbol represents the not equals in SQL?

Answer 22

<>

Question 23

The AND symbol shows what between data sets?

Answer 23

Intersection

Question 24

The OR symbol shows what between data sets?

Answer 24

Union

Question 25

WHAT SQL keyword filters from a list of items.

Answer 25

IN

Question 26

What SQL keyword negates information.

Answer 26

NOT

Question 27

What SQL keyword sorts results?

Answer 27

ORDER BY

Question 28

What do Wild Cards do in SQL?

Answer 28

They create patters that need to be matched.

Question 29

What wild card symbol creates any string of any length?

Answer 29

The percent (%) symbol

Question 30

What wild card symbol matches one single character?

Answer 30

The underscore (_) symbol

Question 31

The LIKE keyword does what?

Answer 31

Searches partial data values.

Question 32

List built in functions in SQL

Answer 32

COUNT
MIN
MAX
SUM
AVG

Question 33

In a Joins Query what is the GOOD method?

Answer 33

Natural Join

Question 34

In a Joins Query what is the BETTER method?

Answer 34

Join On

Question 35

In a Joins Query what is the BEST method

Answer 35

Join Using