ISDS 3003 FINAL CORRECT 100%
Table - ANSWER Relation
Table - ANSWER File
Column - ANSWER Field
Column - ANSWER Attribute
Row - ANSWER Record
Row - ANSWER Tuple
Key - ANSWER One or more columns of a relation that is used to identify a row
Unique Key - ANSWER a key that identifies a unique row
Nonunique Key - ANSWER a key that potentially identifies more than one row
Composite Key - ANSWER a key that potentially identifies more than one row
Composite Key - ANSWER Ex.: (LastName, Department)
Candidate Key - ANSWER an attribute or a group of attributes that identifies a unique
row in a relation
One of the candidate keys is chosen to be the - ANSWER Primary key
Primary Key - ANSWER the candidate key that is chosen as the key that the DBMS will
use to uniquely identify each row in a a relation
Entity Integrity Constraint - ANSWER the constraint that the primary key column or
columns must have unique values so that each row can be uniquely identified
Surrogate Key - ANSWER column with a unique, DBMS-assigned identifier that has
been added to a tablet be the primary key
Ideal Primary Key - ANSWER short and never changes
MySQL uses to automatically assign surrogate key numbers - ANSWER
AUTO_INCREMENT
Identity - ANSWER the attribute specification the tis used to create a surrogate key
, Identity Seed - ANSWER starting value of the surrogate key
Foreign Key Constraint - ANSWER a data constraint between 2 tables requiring that
before a data value can be inserted into a foreign key column, the data value must
already exist in the associated primary key column
5 Component Information System Framework - ANSWER 1. Hardware
2. Software
3. Data
4. Procedures
5. People
Business Process - ANSWER a set of activities that transforms inputs into outputs
3 Steps of Inventory Control Application - ANSWER 1. Input Data
2. Process
3. Output
System Analysis and Design - ANSWER the process of creating and maintaining
information systems
Systems Development Life Cycle (SDLC) - ANSWER the 5 stage cycle used to develop
management information systems
5 Stages of Systems Development Life Cycle - ANSWER 1. System Definition
2. Requirement Analysis
3. Component Design
4. Implementation
5. System Maintenance
1. System Definition - ANSWER where the project requirements and constraints are
established and the project team created
2. Requirement Analysis - ANSWER process that starts withe the project plan as its
input and procedures a set of approved user requirements as its output
3. Component Design - ANSWER process that starts with the approved user
requirements as its input and produces a final system design as its output
4. Implementation - ANSWER process that starts with the final system design as its
input and produces a final system was its output
5. System Maintenance - ANSWER process that starts with the implemented system as
its input and produces an updates system or a request for system modification using the
SDLC as its output
Table - ANSWER Relation
Table - ANSWER File
Column - ANSWER Field
Column - ANSWER Attribute
Row - ANSWER Record
Row - ANSWER Tuple
Key - ANSWER One or more columns of a relation that is used to identify a row
Unique Key - ANSWER a key that identifies a unique row
Nonunique Key - ANSWER a key that potentially identifies more than one row
Composite Key - ANSWER a key that potentially identifies more than one row
Composite Key - ANSWER Ex.: (LastName, Department)
Candidate Key - ANSWER an attribute or a group of attributes that identifies a unique
row in a relation
One of the candidate keys is chosen to be the - ANSWER Primary key
Primary Key - ANSWER the candidate key that is chosen as the key that the DBMS will
use to uniquely identify each row in a a relation
Entity Integrity Constraint - ANSWER the constraint that the primary key column or
columns must have unique values so that each row can be uniquely identified
Surrogate Key - ANSWER column with a unique, DBMS-assigned identifier that has
been added to a tablet be the primary key
Ideal Primary Key - ANSWER short and never changes
MySQL uses to automatically assign surrogate key numbers - ANSWER
AUTO_INCREMENT
Identity - ANSWER the attribute specification the tis used to create a surrogate key
, Identity Seed - ANSWER starting value of the surrogate key
Foreign Key Constraint - ANSWER a data constraint between 2 tables requiring that
before a data value can be inserted into a foreign key column, the data value must
already exist in the associated primary key column
5 Component Information System Framework - ANSWER 1. Hardware
2. Software
3. Data
4. Procedures
5. People
Business Process - ANSWER a set of activities that transforms inputs into outputs
3 Steps of Inventory Control Application - ANSWER 1. Input Data
2. Process
3. Output
System Analysis and Design - ANSWER the process of creating and maintaining
information systems
Systems Development Life Cycle (SDLC) - ANSWER the 5 stage cycle used to develop
management information systems
5 Stages of Systems Development Life Cycle - ANSWER 1. System Definition
2. Requirement Analysis
3. Component Design
4. Implementation
5. System Maintenance
1. System Definition - ANSWER where the project requirements and constraints are
established and the project team created
2. Requirement Analysis - ANSWER process that starts withe the project plan as its
input and procedures a set of approved user requirements as its output
3. Component Design - ANSWER process that starts with the approved user
requirements as its input and produces a final system design as its output
4. Implementation - ANSWER process that starts with the final system design as its
input and produces a final system was its output
5. System Maintenance - ANSWER process that starts with the implemented system as
its input and produces an updates system or a request for system modification using the
SDLC as its output
