BCS 260 Lecture Notes - Database, Fault Tolerance, Database Design

19 views5 pages
1 Jul 2022
Course
Professor

Document Summary

Oracle, don"t need to rewrite everything/ scalable (just make some smaller changes) Leave it to the dbms programmer: the dbms programmer can write them, saving time, the dbms programmer can test them, saving us time, can switch dbmss easily as long as the interface remains the same. This idea is the foundation of relational databases. Relational database contains a collection of separate tables. Table holds data about one and only one theme in most circumstances. If more than one theme, usually have to break up to more tables. Understand how using related tables helps you avoid the problems of using lists. Relational model is a methodology used as a solution for database design. A relational database contains a collection of separate tables. A table holds data about only one theme. Each column, also known as fields, in a table stores a characteristic common to all rows in a table.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related textbook solutions

Related Documents

Related Questions