Concepts of Database Systems

Database system

Ideas of database management-Third version Philip j.pratt .2000

A database is a construction that comprises details about many alternative classes of data and in regards to the relationships between the classes. Premiere merchandise are a distributer of home equipment, housewares. The corporate has used unfold sheet software program to take care of buyer, order, stock and gross sales. The premiere merchandise database, for instance, will comprise details about gross sales, reps, prospects, orders and elements. It should additionally present info that relate gross sales reps to the purchasers they characterize and prospects to the orders they presently have positioned.

With the usage of database, workers can enter the variety of a specific order and discover out which buyer positioned the orders, in addition to which elements have been ordered.

An entity is an individual place object occasion of thought for which you wish to retailer and course of knowledge. An attribute is a attribute or property of an entity. For the entity for instance the record of attributes would possibly embody things like automobile color and measurement.

Rep.

Rep. no.

Final title

First title

Road

Metropolis

State

Zip

Fee

Price

mannequin

Attributes

An attribute can be referred to as a area or column in lots of database programs.

A relationship is an affiliation between entities. There's an affiliation between reps and prospects, for instance at premiere merchandise. A rep is related to all of his or her prospects and a buyer is related to its rep.

One-to-many relationship

Every rep is related to many shoppers, however every buyer is related to just one rep.  in this kind of relationship, the phrase many is used otherwise than in on a regular basis English; it may not at all times point out a big a big quantity. On this context, for instance, the numerous implies that a rep will be related to any variety of prospects. That is, a given rep will be related to zero, one, Or extra prospects.

A database is a construction that may retailer details about a number of varieties of entities, the attributes of these entities, and the connection among the many entities. A database, nevertheless, is far more than a file. Not like a typical knowledge file, a database can retailer details about a number of entities. There's additionally one other distinction. A database holds details about the connection among the many numerous entities. Not solely will premiere merchandise database have details about reps and prospects, it additionally will maintain data relating reps to the purchasers they service, prospects to orders, elements to orders and so forth.

REDUNDANCY

It's the duplication of knowledge or the storing of the identical knowledge in multiple place. Within the orders spreadsheet, redundancy happens within the buyer title column as a result of the title of a buyer is saved in multiple place.

What issues does redundancy trigger?

It wastes area since you are storing the identical knowledge in a number of locations. The additional area ends in bigger spreadsheet that require more room in reminiscence and on disk and that take longer to save lots of and open.

When you should change knowledge, redundancy additionally makes your modifications harder and time consuming.

Lastly redundancy can result in conflicts. For eg. Should you enter somebody’s title and handle in several columns than it's going to take time to enter and there may be probability of constructing errors.