NEW
Font size
WorksheetsG9_Quiz1_2024_Database
Total questions: 22
Worksheet time: 16mins
Which attribute is the COMPOSITE ATTRIBUTE?
Degree
Age
Salary
Address
zero or one
Each entity is described by __________.
entity
relationship
none of these
attribute
This key uniquely identifies each record in an entity.
Primary Key or Key Identifier
Foreign Key
Secondary Key
Composite Key
Diamond shape is symbol for ?
Entity
Cardinality
Relationship
Atribut
This shape is symbol for ?
Atribut
Relationship
Entity
Cardinality
For ERD this shape describe for ?
Cardinality
Relationship
Attribute
Entity
HOUSE/POSTCODE
For the following two ENTITIES, which is the appropriate relationship:
ACTOR / MOVIE
One to One
One to Many
Many to Many
Some examples of relational databases include
Microsoft SQL Server
MySQL
Oracle
All of the above
DBMS is...
a software used to create, update and delete user profiles in a computer system
a software used to only update a database in a computer system
a software that handles the storage, retrieval, and updating of data in a computer system.
a software used to alter the memory cache in a computer system
The names assigned to each piece of data and their data types are known as
Identifiers
Data definitions
Administration
Security
What is a database?
A software package used to store information
Something that has a list
A spreadsheet
A table of data
Who might use a database?
School
Police
Employer
All of the above
What is an advanage of a database?
You can input information
Its different to Excel
It saves files
Can search through and find information quickly
