WAEC May/June 2024 - Practice for Objective & Theory - From 1988 till date, download app now - 99995
WAEC Past Questions, Objective & Theory, Study 100% offline, Download app now - 24709

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
WAEC Past Questions, Objective & Theory, Study 100% offline, Download app now - 24709
WAEC offline past questions - with all answers and explanations in one app - Download for free
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 - Original materials are available here - Download PDF for your school of choice + 1 year SMS alerts
WAEC Past Questions, Objective & Theory, Study 100% offline, Download app now - 24709
WAEC offline past questions - with all answers and explanations in one app - Download for free

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
WAEC May/June 2024 - Practice for Objective & Theory - From 1988 till date, download app now - 99995
WAEC Past Questions, Objective & Theory, Study 100% offline, Download app now - 24709
WAEC offline past questions - with all answers and explanations in one app - Download for free
WAEC Past Questions, Objective & Theory, Study 100% offline, Download app now - 24709
WAEC offline past questions - with all answers and explanations in one app - Download for free
Post-UTME Past Questions - Original materials are available here - Download PDF for your school of choice + 1 year SMS alerts
WAEC May/June 2024 - Practice for Objective & Theory - From 1988 till date, download app now - 99995