Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL

memorize.ai (lvl 286)

(0)

11 cards

()

Section 1

Preview this deck

Second Normal Form (2NF)

Front

1 / 11

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (11)

Section 1

(11 cards)

Second Normal Form (2NF)

Front

(dependence) finding the relation between tables so that dependent data is referenced and not duplicated. (any dependent data is referenced via foreign key)

Back

Normilization

Front

the process by which we structure our data to find relations between tables. so we limit duplication and increase readability/write-ability reduce redundancy .

Back

Primary Key

Front

What is a primary key? In the world of databases, the primary key of a relational table uniquely identifies each record in the table.

Back

Reference / Foreign Key

Front

A foreign key is a column or group of columns in a relational database table that provides a link between data in two tables. It acts as a cross-reference between tables because it references the primary key of another table, thereby establishing a link between them.

Back

Object Relational Mapper (ORM)

Front

1) ORM is going to match a table to a class or a struct and those two things are entities in their container.

Back

Un-Clustered Index

Front

You can have the same word but depending on the page, the word is in on you can have a different definition.

Back

Object in C# => What in SQL Class in C# => What in SQL

Front

a class in c# is a Table in SQL a object is c# is an instance => a row in SQL a property of an object is a Column in SQL

Back

Third Normal Form (3NF)

Front

A relation that is in second normal form and has no transitive dependencies. A dependency is said to be transitive if it is formed from two functional dependencies. why do we do 3NF , to ensure referential integrity and reduce redundancy.

Back

Clustered Index

Front

Arranged in a special order to make retrieval of data faster with direct access to the data can only be 1 entry in that index

Back

Unique Key

Front

Data value is unique for each row. Consequently, the key will uniquely identify a row.

Back

First Normal Form (1NF)

Front

A relation that has a primary key and in which there are no repeating groups. (Atonic) each row identifies a single instance of an object.

Back