Loading presentation...

Present Remotely

Send the link below via email or IM


Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.


CIS135DB: Relational Database

No description

Barbara Klett

on 28 March 2011

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of CIS135DB: Relational Database

Data: Raw information that can be manipulated by a computer. Database: A structured collection of information. Mark Twain Charles Dickens The Advenutes of Huckleberry Finn Oliver Twist Information: What we know about something. Here is our data in a simple spreadsheet: Field: A column describing one attribute of a person, person, place, or thing. This is the Last Name Field Record: A set of fields that describe a single person, place, or thing. This is the record on Charles Dickens in our database Flat File Database Flat File Database Gets Complicated Spreadsheets can store data, but they do pose some problems because data is often duplicated and lacks rules to keep it valid. Another problem is updating, deleting and inserting things to the spreadsheet. There can easily be referencial integrity issues. Relational Databases Table: Set of data organized as Rows and Columns. Relational Databases use TABLES to separate data by KIND. Primary Key: A field that uniquely identifies each record in a table. Book Table Author Table Foreign Key: A field identifying a key for a different record. Accomplished Goals: Know the meaning of the terms: Data Field Record Keys Table Primary Key Foreign Key Relational Database Database Flat File Database Used raw data to set up a very simple flat-file database. Set up a one-to-many Relational Database. Learning Outcomes: Use basic database management terminology Create a flat file database Set up a one-to-many relational database In this example, Keys are identifiers that match authors and books By using the structure of a relational database, the data is easier to edit, and it is more likely to be valid. CIS 135DB: Database Theory 1838 1885 (activity) Incorrectly formatted One-to-Many Relationship: One author can have MANY Authored records. (matching activity) relational database activity + Quiz 1838 1885 Why would you use a relational database rather than a flat-file database? Database is a system designed to organize, store and retrieve data easily, and help turn that data into usable information. Data in >>>Information out JOIN the split tables. Tables are joined together, again, using the value of the data. THIS provides a solid foundation for user forms and reports. Entry / Entity (examples)
Full transcript