Font size
WorksheetsIntroductionDatabases
Total questions: 20
Worksheet time: 11mins
Which attribute is the COMPOSITE ATTRIBUTE?
Degree
Age
Salary
Address
Which attribute is the PRIMARY KEY?
Each entity is described by __________.
entity
relationship
none of these
attribute
This key uniquely identifies each record in an entity.
Primary Key
Foreign Key
Super Key
Composite Key
This key is suitable to become a primary key in an entity.
Candidate Key
Foreign Key
Super Key
Composite Key
If you were collecting and storing information about your music collection, an album would be considered as a(n) _____.
A software that we would use to create a database is
Microsoft Publisher
Microsoft Excel
Microsoft Word
Microsoft Access
In a database, data is stored in
Tables
Forms
Reports
Queries
______________ is a view of information arranged in a grid of rows and columns.
Record
Field
Table
Column
This allows you to store information, retrieve, and use of data in various ways.
Spreadsheet
Word Processor
Database
This indicates the type of data that can be entered into a column or field
Data type
Field type
Field name
Record information
What is a database?
A
collection of
related tables.
A system that is used to store, and use data
A
collection of
related data.
A table with rows.
An Entity-relationship diagrams is
Why do we need databases?
What is a Database Management System?
A software system that enables users to create, maintain and access the database.
A collection of related data
Select Database Management Systems
My SQL
NOSQL
Mongo DB
Python
Microsoft SQL Server is a
a Database Management Systems
a collection of tables
language to create a database
A tool to create, access and maintain a database
