Chapter 16 - Database concepts

No description yet. This curated deck is ready for daily study.

Total cards: 24•Content version: v4•Public deck•Updated: 8/1/2026

Card preview (24)

Front (Question)

What is an entity?

Back (Answer)

» Entity is a category of object,person,event or thing of interest to an organisation about which data is to be recorded

Front (Question)

What does each entity in a database have?

Back (Answer)

» List of attributes/fields

Front (Question)

What is another name for a simple database?

Back (Answer)

» Called a flat file, consiting of information about a single entity - consisting of a single file

Front (Question)

What is the format of an entity discription?

Back (Answer)

» Entity1(Attribute1, Attribute2…)

Front (Question)

What is an example of a discription for an entity which is called product?

Back (Answer)

» Product(Title,Subject,Author,Length)

Front (Question)

What is needed to uniquely identify the entity?

Back (Answer)

» An Identifier

Front (Question)

What is the identifier known as in a relational database?

Back (Answer)

» Primary key

Front (Question)

What is the purpose of the primary key?

Back (Answer)

» To identify a particular record relationship database

Front (Question)

What is the format for a primary key?

Back (Answer)

» Customer(CustId,title,firstname) » CustId is the primary key in this instant as it is unique

#10

Front (Question)

Why is a secondary index needed

Back (Answer)

» To search the database quickly such as the surname in a patients file

#11

Front (Question)

What is a composite primary key?

Back (Answer)

» A primary key which consists of more than one attribute is called a composite primary key

#12

Front (Question)

What are the 3 different degrees of relationship between 2 entities?

Back (Answer)

» One-to-one » One-to-many » Many-to-many

#13

Front (Question)

What is an example of a one to one relationship?

Back (Answer)

» A husband and wife

#14

Front (Question)

What is an example of a one to many relationship?

Back (Answer)

» Mother and a child » As a mother may have many children, but each child has the same mother

#15

Front (Question)

What is an example of a many to many relationship?

Back (Answer)

» Film and actor

#16

Front (Question)

What is the purpose of an entity relationship diagram?

Back (Answer)

» A diagrammatic way of representing the relationships between the entities in a databse

#17

Front (Question)

What 2 things needed to be specified in a E-R diagram?

Back (Answer)

» The degree of relationship » The name of the relationship

#18

Front (Question)

Describe the E-R diagram of a Headteacher and a School

Back (Answer)

» One to one relationship » Headteacher in charge of School

#19

Front (Question)

What is created in a relational database?

Back (Answer)

» A seperate table is created for each entity identified in thre system

#20

Front (Question)

What is the foreign key?

Back (Answer)

» An extra field/attribute that links the 2 tables

#21

Front (Question)

What is the purpose of the Foreign key?

Back (Answer)

» An attribute that creates a join between two tables » Attribute that is common to both tables » Primary key in one table is the foreign key in the table to which it is linked

#22

Front (Question)

What is the primary key indicated by?

Back (Answer)

» Asterisk

#23

Front (Question)

What is the foreign key indicated by?

Back (Answer)

» Italics

#24

Front (Question)

How is the one-to-one degree shown in an E-R diagram?

Back (Answer)

» A straight line