Name: Premiere Products Company
Premiere Products, a distributor of appliances, housewares, and sporting goods is a fictitious company that will use spreadsheet software to maintain company's data. Premiere Products must maintain information about sales reps, customers, and parts inventory as well as store information about orders. The company needs to maintain data on more than one category (customers, sales reps, orders, parts) and is interested in the relationships between the categories.
- The database terms entity, attribute, and relationship. An entity is a person, place, object, event, or idea for which you want to store and process data. An attribute is a characteristic or property of an entity. A relationship is an association between entities. The one-to-many relationship that exists between sales reps and customers in the Premiere Products database. In a database system, a one-to-many relationship is handled by using common columns in the two tables. A database is a structure that can store information about multiple types of entities, the attributes of those entities, and the relationships among the entities. A data file (a file used to store data) is not the same as a database.
- Benefits of Database System
The advantages of database system are: getting more information from the same amount of data; sharing data; balancing conflicting requirements; controlling redundancy; facilitating consistency; improving integrity; expanding security; increasing productivity; and providing data independence. - Disadvantages of Database System
The disadvantages of database system are: larger file size; increased complexity; greater impact of failure; and more difficult recovery.
www.cs.indiana.edu/classes/a114-dger/fall2002/notes/Eight.html - Cached
Aileen Grace V. Siguenza BSC-MA3 7:15-8:15 pm
No comments:
Post a Comment