SMG IS 223 Lecture Notes - Lecture 6: Database Design, Unique Key, Database
21 Jun 2018
School
Department
Course
Professor
What are the contents of a database?
oWhat are the relationships among rows
Key: a field in one table that appears as a field in another table
Primary key: one or many fields that identify a unique row in a table
Foreign key: one or many fields in one table that appears as a primary
key in another table
Converting ERDs to a Database Design
oErd if logical model→ database is the physical model
oEntities become tables
oAttributes become table columns
oColumns are fields
The Database Management SYstem is the translator between the computer programs
that do the business processes and the data at rest in the relational database.
oThe DBMS is a specific type of computer program
oThe DBMS finds and updates the data at rest that is needed by the computer
application programs that are doing the business processes among other things
oProgram used to create, process, and administer a database
Entities become Table
find more resources at oneclass.com
find more resources at oneclass.com
