Post UTME Past Questions Agent
WAEC and NECO CBT Software for Computers and Laptops - Candidates, Schools, Centres, Resellers - 100% Offline -Download Now

2019 WAEC Data Processing Theory (a) Explain the following database management terms; (i) entities (ii) attributes (iii) relationships (b)(i) Define...

Data Processing
WAEC 2019

(a) Explain the following database management terms; (i) entities (ii) attributes (iii) relationships

(b)(i) Define cardinality in database management.

(ii) Mention three cardinality relationships database management.

Post-UTME Past Questions - Original materials are available here - Download PDF for your school of choice + 1 year SMS alerts
Post UTME Past Questions Agent
WAEC and NECO CBT Software for Computers and Laptops - Candidates, Schools, Centres, Resellers - 100% Offline -Download Now
Explanation

(a)(i) Entities;- An entity is an object in the system that we want to model and store information about. Entities are usually recognizable concepts either concrete or abstract such as persons, places. things or events which have relevance to the database.

(ii) Attribute (Characteristics); It is a database component such as a table. It is also seen as a database field, they describe the instances in the row of a database. OR It is a column or field in a database table.

(iii) Relationships; A relationship in the context of database is a situation that exists between two relational database tables when one table has a foreign key that references the primary key to the other table. A relationship allows relational database to split and store data in different tables, while linking disparate data items.

(b((i) Cardinality; This refers to the uniqueness of data values contained in a column. High cardinality means that the column contains a large percentage of totally unique values. Low cardinality means that the column contains alot of "repeals" in its data range.

(ii) Three cardinality relationships in database management; 

I. One-to one (1:1) relationship

II. One-to-many (1-M) relationship

III. Many-to-many (M:M) relationship


Report an Error Ask A Question Download App
Post UTME Past Questions Agent
Your School's Whatsapp Group - Join Us now
WAEC and NECO CBT Software for Computers and Laptops - Candidates, Schools, Centres, Resellers - 100% Offline -Download Now

Contributions ({{ comment_count }})

Please wait...

{{ settings.no_comment_msg ? settings.no_comment_msg : 'There are no comments' }}

Quick Questions

Post your Contribution

Please don't post or ask to join a "Group" or "Whatsapp Group" as a comment. It will be deleted. To join or start a group, please click here

{{ quote.posted_by.display_name }}
{{ settings.form_textarea_description }}
 
Post-UTME Past Questions - Original materials are available here - Download PDF for your school of choice + 1 year SMS alerts
Post UTME Past Questions Agent
WAEC and NECO CBT App for Mobile Devices - Candidates, Schools, Centres, Resellers - 100% Offline -Download Now
Your School's Whatsapp Group - Join Us now
WAEC and NECO CBT Software for Computers and Laptops - Candidates, Schools, Centres, Resellers - 100% Offline -Download Now
Post-UTME Past Questions - Original materials are available here - Download PDF for your school of choice + 1 year SMS alerts
WAEC and NECO CBT Software for Computers and Laptops - Candidates, Schools, Centres, Resellers - 100% Offline -Download Now
Your School's Whatsapp Group - Join Us now
WAEC and NECO CBT App for Mobile Devices - Candidates, Schools, Centres, Resellers - 100% Offline -Download Now