Organization of data as relations.

By -

Organization of data as relations

RELATIONS

Entity sets and relationship sets are useful in designing data bases. Entity - relationship sets may be put as a table of values. This is called a Relation. Relation name is entity name. A row of a relation has members of its attributes. The column headings are the names of the attributes.

EXAMPLES OF A RELATION

image

RELATION NOTATION

Relation is an entire table

• Vendor relation:

image

WHY RELATION ?

Entity set can be easily stored as a flat file in a computer's storage Sound theory of relations allows systematic design of relational data base, reduces duplication of data, tries to eliminate errors in adding, deleting, altering items in a data base and simplifies retrieval of data.

Comments

Post a Comment

Popular posts from this blog

Role of systems analyst, attributes of system analyst, tools used in system analysis

By -
Image
Role of systems analyst, attributes of system analyst, tools used in system analysis ROLE OF SYSTEMS ANALYST The following are roles of systems analyst: 1. Defining Requirement s: Involves Interviewing Users 2. Prioritizing Requirements: Obtain Users Consensus 3. Fact Gathering: Data, Facts and opinions of Managers are gathered, Lower level Users should also be consulted 4. Analysis and evaluation - Arrive at appropriate system 5. Solving problems: Hazy requirements converted into specific requirements, suggest many alternative solutions, and quantify cost and benefits 6. Drawing up specifications: Draw up specifications which are understood by users and programmers, which are accepted by users and which are precise and detailed. 7. System design: Logical design of system is implemented and the design must be modular 8. Evaluating Systems: Evaluate the system after it has been used for sometime, Plan the periodicity for evaluation and modify the system as needed ATTRIBUTES...
Read more

Examining alternative solutions and evaluating proposed solutions.

By -
Image
Examining alternative solutions and evaluating proposed solutions EXAMINING ALTERNATIVE SOLUTIONS HOSTEL INFORMATION SYSTEM ALTERNATIVE SOLUTIONS A: Improve manual system B: Use PC based periodic update system C: An on-line system with server and several clients SOLUTION A: MANUAL SYSTEM Keep up-to-date running total of extras and rebates for each student, use look up table to find material needed each day based on number of extras, calculate standard quantities needed and use for vendor order, track student payments to find overdue payments. Solution does not ensure reduction in bill variations and prompt payment to vendors, solution not scalable to large student population SOLUTION B: USE PC BASED PERIODIC UPDATE SYSTEM Use a single PC to prepare students bills and to itemize bills, prepare a list of number of members who will eat for next two days, alert warden when bill is not paid within 10 days of issue. Use a PC to generate Vendor order, Inventory control of store an...
Read more