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

WORKED EXAMPLES ON PROCESS SPECIFICATION.

By -
Image
PROCESS SPECIFICATION WORKED EXAMPLES 6.1 A bank has the following policy on deposits: On deposits of Rs. 5000 and above and for three years or above the interest is 12%. On the same deposit for a period less than 3 years it is 10%. On deposits below Rs. 5000 the interest is 8% regardless of the period of deposit. Write the above process using (i) Structured English (ii) A decision table 6.2 An organization maintains an employee file in which each record has following data: { Employee No., employee name, employee gross pay}. It has been decided to increase the pay as per the following formula: For pay of Rs. 1000 or less increase 15%. For pay of more than Rs. 1000 but up to Rs. 2500 increase 10%. For pay over Rs. 2500 increase 5%. (i) Writ e a structured English processing rule corresponding to the above policies. (ii) Express the policies as a decision table. (i) While employee records left in file do Read Number, name , gross pay 6.3 An offshore gas company bills it...
Read more

The User Interface:Establishing User Interfaces

By -
Image
The User Interface Establishing User Interfaces The success factors in analysis start with the established interfaces from day one. What does this mean? You must start the process by meeting with the right people in the organization. In the best projects, the process is as follows: 1. Executive interface: There needs to be an executive-level supporter of the project. Without such a supporter, you risk not being able to keep the project on schedule. Most important, you need a supporter for the political issues that you may need to handle during the project (discussed in detail later). The executive supporter, sometimes known as a sponsor (JAD reference), should provide a preliminary schedule advising the organization of what is expected and the objectives of the project. The executive supporter should attach a letter to the preliminary schedule and send it to the project team members. The letter must put the importance of the project into perspective. Therefore, it is strongly rec...
Read more

Data processing: Decentralized DP, using manual methods

By -
Image
Decentralized DP, using manual methods This method of processing data is still often used, especially in small organizations. The advantages of this way of processing over traditional data processing centralized on a DP department include: • Users can access data in their own way and at their own times, instead of having to conform to the requirements of a central facility. So urgent matters and enquiries can be dealt with promptly. • Users can input data directly into the system instead of filling in and sending source documents to the DP department for input. • Since the processing facilities are decentralized, it is less likely that a machine breakdown or a strike by a handful of people will disrupt the entire organization. The disadvantages are mainly that it is a slow, labour­ intensive way of processing data, and its accuracy is inferior to that achieved by other methods. Centralized DP, using computers Centralized DP came in with the introduction of punched...
Read more