B ITM 330 Lecture Notes - Lecture 1: Data Redundancy, Microsoft Access, Database

50 views3 pages

Document Summary

In a list, each row is intended to stand on its own. As a result, the same information may be entered several times: for example: a list of projects may include the project manager"s name, If a particular person is managing 10 projects, his/her information would have to be entered 10 times. In a list, each row may contain information on more than one theme. Redundancy and multiple themes create modification problems: deletion problems, update problems. In essence, a relational database will break-up a list into several parts one part for its own table. each theme in the list: a project list would be divided into a customer table, a. In our relational database, we broke our list into several tables. In a relational database, tables are joined together using the value of the data. must be joined back together. If a project has a customer, the customer_id is stored as a column in the project 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 Documents