1.4 Database Design and Programming

0.0(0)
studied byStudied by 0 people
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/6

encourage image

There's no tags or description

Looks like no tags are added yet.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

7 Terms

1
New cards

database design: analysis

  • specifies database requirements without regard to a specific database system.

  • Requirements are represented as entities, relationships, and attributes.

  • Sometimes called: Conceptual Design

2
New cards

ER diagrams

Entities, relationships, and attributes are depicted in (blank).

3
New cards

database design: logical design

  • implements database requirements in a specific database system.

  • For relational database systems, (blank) converts entities, relationships, and attributes into tables, keys, and columns.

  • The (blank) as specified in SQL and depicted in a table diagram, is called a database schema.

4
New cards

key

  • a column used to identify individual rows of a table.

  • Tables, keys, and columns are specified in SQL with CREATE TABLE statements.

5
New cards

database design: physical design

  • adds indexes and specifies how tables are organized on storage media.

  • (blank) affects query processing speed but never affects the query result.

6
New cards

data independence

  • The principle that physical design never affects query results is called (blank).

  • Physical affects query processing speed but never affects the query result.

  • When database designers modify indexes or row order, applications run faster or slower but always generate the same results.

7
New cards

application programming interface / API

is a library of procedures or classes that links a host programming language to a database.