B ITM 330- Final Exam Guide - Comprehensive Notes for the exam ( 53 pages long!)

• School: SUNY Albany
• Department: Information Technology Management
• Course: B ITM 330
• Professor: Jakov Crnkovic

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.