CIT 111 FINAL EXAM REV || with 100% Verified
Solutions.
FIXED LENGTH FILE correct answers text file, each column has a fixed width
DELIMITED FILE correct answers columns are separated by a value (delimitter) like a comma
REDUNDANCY correct answers The same data is repeated in several places of the database.
DATA INTEGRITY correct answers Refers to the accuracy and quality of the data
RELATIONAL DATABASE correct answers database that works with relationships between
different tables (foreign keys, primary keys, etc.)
RDBMS correct answers Relational DataBase Management System
SERVER correct answers Provides services to the client (i.e. a web server)
CLIENT correct answers Requests a service from a server (i.e. a web browser requesting
information from a web server)
LOGICAL DESIGN correct answers The design of a database without regard to the physical
design of the database
PHYSICAL DESIGN correct answers A diagram of tables and columns that portrays the
relationships between separate data tables- includes DBMS-specific data types, file locations,
etc.
ERD - ENTITY RELATION DIAGRAM correct answers A diagram of tables that shows the
relationships between separate tables as illustrated in SQL
CROW'S FEET NOTATION correct answers notation used to illustrate the relationships
between physical design tables
ENTITY correct answers An object of concern to a database, such as a customer or sale. Used in
the logical design phase of a database
ATTRIBUTE correct answers A part of an entity, e.g. the price of a sale
TABLE correct answers A 2 dimensional representation of an entity and it's attributes/ values
COLUMN correct answers A part of a table
ROW correct answers the rows of a table
, ONE TO ONE correct answers There is one "a" for every "b", and one "b" for every "a". For
instance, there is only one contract for each customer, and only one customer for each contract
ONE TO MANY correct answers There is only one "a" for many "B's". There is only one
customer for many sales
MANY TO MANY correct answers There are many "a's" for many "b's". There are many
customers for many products, and many products purchased by many customers
CARDINALITY correct answers The limit on the number of allowances in a relationship. For
instance, in a one to many relationship, each A is only allowed a certain amount of B's
LINKING ENTITY correct answers A table between two other tables that allows a many to
many relationship to work by separating them into two one-to-many relationships
PRIMARY KEY correct answers The key by which the data is classified- It helps you to locate
the rest of the data in the table. One column by which the data in the rows are located and
referenced
FOREIGN KEY correct answers A primary key from a different table inserted into a different
table to save space and make tables more readable- like a reference to a different table.
CANDIDATE KEY correct answers A possible primary key, a candidate for it
COMPOSITE KEY correct answers A key which requires two or more natural primary keys of
information to classify the data
NATURAL KEY correct answers A natural part of the data by which you classify the rest of it.
E.G., "LastName", or "PhoneNumber", etc. This is what you would look up the rest of your
information with
SURROGATE KEY correct answers An artificially auto-incremented key used to classify the
data. 1,2,3,4,5, etc. This allows for an always unique key definition, instead of having the
possibility of duplication in a natural key (two people having the same last name or phone
number)
NOT NULL CONSTRAINT correct answers Not "unrequired", this data is required in order to
input the whole row of data
PRIMARY KEY CONSTRAINT correct answers The primary column by which the rest of the
columns are referred to
FOREIGN KEY CONSTRAINT correct answers A primary key of another table being referred
to in a different table
Solutions.
FIXED LENGTH FILE correct answers text file, each column has a fixed width
DELIMITED FILE correct answers columns are separated by a value (delimitter) like a comma
REDUNDANCY correct answers The same data is repeated in several places of the database.
DATA INTEGRITY correct answers Refers to the accuracy and quality of the data
RELATIONAL DATABASE correct answers database that works with relationships between
different tables (foreign keys, primary keys, etc.)
RDBMS correct answers Relational DataBase Management System
SERVER correct answers Provides services to the client (i.e. a web server)
CLIENT correct answers Requests a service from a server (i.e. a web browser requesting
information from a web server)
LOGICAL DESIGN correct answers The design of a database without regard to the physical
design of the database
PHYSICAL DESIGN correct answers A diagram of tables and columns that portrays the
relationships between separate data tables- includes DBMS-specific data types, file locations,
etc.
ERD - ENTITY RELATION DIAGRAM correct answers A diagram of tables that shows the
relationships between separate tables as illustrated in SQL
CROW'S FEET NOTATION correct answers notation used to illustrate the relationships
between physical design tables
ENTITY correct answers An object of concern to a database, such as a customer or sale. Used in
the logical design phase of a database
ATTRIBUTE correct answers A part of an entity, e.g. the price of a sale
TABLE correct answers A 2 dimensional representation of an entity and it's attributes/ values
COLUMN correct answers A part of a table
ROW correct answers the rows of a table
, ONE TO ONE correct answers There is one "a" for every "b", and one "b" for every "a". For
instance, there is only one contract for each customer, and only one customer for each contract
ONE TO MANY correct answers There is only one "a" for many "B's". There is only one
customer for many sales
MANY TO MANY correct answers There are many "a's" for many "b's". There are many
customers for many products, and many products purchased by many customers
CARDINALITY correct answers The limit on the number of allowances in a relationship. For
instance, in a one to many relationship, each A is only allowed a certain amount of B's
LINKING ENTITY correct answers A table between two other tables that allows a many to
many relationship to work by separating them into two one-to-many relationships
PRIMARY KEY correct answers The key by which the data is classified- It helps you to locate
the rest of the data in the table. One column by which the data in the rows are located and
referenced
FOREIGN KEY correct answers A primary key from a different table inserted into a different
table to save space and make tables more readable- like a reference to a different table.
CANDIDATE KEY correct answers A possible primary key, a candidate for it
COMPOSITE KEY correct answers A key which requires two or more natural primary keys of
information to classify the data
NATURAL KEY correct answers A natural part of the data by which you classify the rest of it.
E.G., "LastName", or "PhoneNumber", etc. This is what you would look up the rest of your
information with
SURROGATE KEY correct answers An artificially auto-incremented key used to classify the
data. 1,2,3,4,5, etc. This allows for an always unique key definition, instead of having the
possibility of duplication in a natural key (two people having the same last name or phone
number)
NOT NULL CONSTRAINT correct answers Not "unrequired", this data is required in order to
input the whole row of data
PRIMARY KEY CONSTRAINT correct answers The primary column by which the rest of the
columns are referred to
FOREIGN KEY CONSTRAINT correct answers A primary key of another table being referred
to in a different table
