4.1 Database Design And Concepts

Question 1

ASCII

Answer 1

[American Standard Code for Information Interchange]

Question 2

Byte

Answer 2

Collection of 8 bits - the smallest unit of storage in a computer system.

Question 3

DLL files

Answer 3

[Dynamic Link Libraries]

Files that contain code or routines that can be called and used by programs.

Question 4

Font file - Extension

Answer 4

TTF or OTF

Question 5

HTML files

Answer 5

Define the structure and layout of a web page.

Question 6

Overflow

Answer 6

Error condition that occurs when there aren’t enough bits available to represent an integer value accurately.

Question 7

PDF

Answer 7

[Portable Document Format]

Question 8

Plain text file - Extension

Answer 8

.txt

Question 9

Program file - Extension

Answer 9

.COM or .EXE

Question 10

Truncation

Answer 10

Misrepresentation of a string variable because there aren’t enough bytes available to store all the characters in the string.

Question 11

Wildcard

Answer 11

Characters that present one or more characters.

Question 12

Accuracy

Answer 12

Refers to the fact that the data is ‘right’

Question 13

Composite keys

Answer 13

Combination of more than one field to uniquely identify a record.

Question 14

Data integrity

Answer 14

Overall completeness, accuracy and consistency of data. When each record has a unique primary key and when a foreign key refers to an existing record in another table.

Question 15

Data maintenance

Answer 15

Adding or deleting records or updating data.

Question 16

Data redundancy

Answer 16

Unnecessary repetition of data.

Question 17

Data verification

Answer 17

Checking for the accuracy of data from a human perspective.

Question 18

Data validation

Answer 18

Any technique used to reduce the number of errors that can be made during input of data by ensuring data meets a set of requirements.

Question 19

Database

Answer 19

Collection of data or facts regarding a specific topic.

Question 20

DBA

Answer 20

[Database Administrator]

Manages and maintains databases. Supervises users and their access rights and performs routine maintenance.

Question 21

Database analyst

Answer 21

Analyses the efficiency of the system, analysis and design activities of the database.

Question 22

DBMS

Answer 22

[Database Management System]

Software that allows you to work with electronic databases. (MySQL, Oracle, Microsoft Access)

Question 23

Database programmer

Answer 23

Responsible for coding the custom-made software that is the user interface to the database.

Question 24

Delete anomaly

Answer 24

Database is designed in a way that deleting one piece of data results in the simultaneous removal of other, unrelated data.

Question 25

Desktop database

Answer 25

DB software where the tools you need to work with the data are all included in a single application.

Question 26

Distributed database

Answer 26

System where parts of a database are spread across servers in different locations.

Question 27

ER Diagrams

Answer 27

[Entity Relationship Diagrams]

Illustrates relationships between entities.

Question 28

Foreign key

Answer 28

Field that’s used as a ‘link’ to a field in another table.

Question 29

Insert anomaly

Answer 29

Database is designed in a way that prevents a user from capturing data when they want or need to.

Question 30

Primary key

Answer 30

Field that identifies each record with a unique value.

Question 31

Relational database

Answer 31

Database containing many tables linked together in relationships.

Question 32

Server DBMS software

Answer 32

DB software that’s installed on a server and is never directly accessed by the user.

Question 33

Update anomaly

Answer 33

Database is designed in way that when an item of data changes or is updated, it has to be updated in multiple records or tables.