SDSU MIS 180 Meader Spring Final
Questions With All Correct & Verified
Answers
Entity Correct answer-also called a table, stores information about a person, place, thing,
transaction, or event
ex: A customer is an entity, as is a merchandise item
Attribute Correct answer-the data elements associated with an entity
Ex: first name, last name, zip code, phone number = field
Stored Attribute Correct answer-the actual attribute stored in the DBMS, used to derive other
attributes
Derived Attribute Correct answer-calculated using the value of another attribute
Ex: stored = DOB derived = current date - DOB (age)
Entity Relationship Diagram Correct answer-shows the relationship of entity sets stored in a
database
One to one (1:1) Correct answer-the airport is in one town and the town only has one airport
One to many (1:M) Correct answer-ex: one customer can make many orders, the order can contain
many items
Many to many (M:M): Correct answer-ex: many customers can order the same item
Primary Key Correct answer-a field that identifies a given records in a table, lets you retrieve every
single piece of data put into a database
ex: customer ID, redid
(No possible duplicates)
Foreign Key Correct answer-a primary key of one table that appears as an attribute in another
table and acts to provide a logical relationship between the two files
Project Correct answer-Project: a temporary activity a company undertakes to create a unique
product, service or result
Scope Correct answer-what the product will include, what problem is being solved, justifications,
requirements, and boundaries
Scope Creep Correct answer-when scope grows without budget and schedule also growing
Milestones Correct answer-points in time at which a task will be done
, Task Sequencing Correct answer-designing the tasks to leverage your team, and get the projects
done as quickly as possible (PERT chart, Gantt Chart)
PERT chart Correct answer-statistical tool used to analyze and represent tasks involved in
completing a given project, manages the dependencies and best sequencing of tasks, lays out the
order/Inter-relationships of tasks
Critical Path Correct answer-the path that takes the leads amount of time to complete (minimum
time). The critical path has no slack
Slack Time Correct answer-the difference between a project's latest and earliest finishing time.
How much an activity can be delayed beyond its earliest start date without causing problems in the
completion of a project by its due date.
3 ways Projects Fail Correct answer-o Takes too long
o Costs too much
o Wrong scope functionality
System Development Life Cycle (SDLC) Correct answer-The overall process for developing
information systems, from planning and analysis, through implementation
Planning
Analysis
Design
Development
Testing
Implementation
Maintenance
Waterfall Correct answer-a sequence of phases in which the output of each phase is the input for
the next (no longer adequate in many cases because of the growing competitiveness and innovation)
Agile Model Correct answer-aims for customer satisfaction through early and continuous delivery
of useful software components developed by an interactive process using the minimum
requirements. Rapid prototyping and software/application development
Economic Feasibility Correct answer-measures the cost effectiveness of a project
Operational Feasibility Correct answer-measures how well a solution meets the identified
requirements to solve the problem
Schedule Feasibility Correct answer-measures the project time frame to ensure it can completed
on time
Technical Feasibility Correct answer-measures the practicality of a technical solution and the
availability of technical resources and enterprise, is the technology available and easy enough to use
Gap Analysis Correct answer-the comparison of actual performance with potential or desired
performance with potential or desired performance
How do we move from the current state to the desired state
eBusiness Model Correct answer-o Relationship
Questions With All Correct & Verified
Answers
Entity Correct answer-also called a table, stores information about a person, place, thing,
transaction, or event
ex: A customer is an entity, as is a merchandise item
Attribute Correct answer-the data elements associated with an entity
Ex: first name, last name, zip code, phone number = field
Stored Attribute Correct answer-the actual attribute stored in the DBMS, used to derive other
attributes
Derived Attribute Correct answer-calculated using the value of another attribute
Ex: stored = DOB derived = current date - DOB (age)
Entity Relationship Diagram Correct answer-shows the relationship of entity sets stored in a
database
One to one (1:1) Correct answer-the airport is in one town and the town only has one airport
One to many (1:M) Correct answer-ex: one customer can make many orders, the order can contain
many items
Many to many (M:M): Correct answer-ex: many customers can order the same item
Primary Key Correct answer-a field that identifies a given records in a table, lets you retrieve every
single piece of data put into a database
ex: customer ID, redid
(No possible duplicates)
Foreign Key Correct answer-a primary key of one table that appears as an attribute in another
table and acts to provide a logical relationship between the two files
Project Correct answer-Project: a temporary activity a company undertakes to create a unique
product, service or result
Scope Correct answer-what the product will include, what problem is being solved, justifications,
requirements, and boundaries
Scope Creep Correct answer-when scope grows without budget and schedule also growing
Milestones Correct answer-points in time at which a task will be done
, Task Sequencing Correct answer-designing the tasks to leverage your team, and get the projects
done as quickly as possible (PERT chart, Gantt Chart)
PERT chart Correct answer-statistical tool used to analyze and represent tasks involved in
completing a given project, manages the dependencies and best sequencing of tasks, lays out the
order/Inter-relationships of tasks
Critical Path Correct answer-the path that takes the leads amount of time to complete (minimum
time). The critical path has no slack
Slack Time Correct answer-the difference between a project's latest and earliest finishing time.
How much an activity can be delayed beyond its earliest start date without causing problems in the
completion of a project by its due date.
3 ways Projects Fail Correct answer-o Takes too long
o Costs too much
o Wrong scope functionality
System Development Life Cycle (SDLC) Correct answer-The overall process for developing
information systems, from planning and analysis, through implementation
Planning
Analysis
Design
Development
Testing
Implementation
Maintenance
Waterfall Correct answer-a sequence of phases in which the output of each phase is the input for
the next (no longer adequate in many cases because of the growing competitiveness and innovation)
Agile Model Correct answer-aims for customer satisfaction through early and continuous delivery
of useful software components developed by an interactive process using the minimum
requirements. Rapid prototyping and software/application development
Economic Feasibility Correct answer-measures the cost effectiveness of a project
Operational Feasibility Correct answer-measures how well a solution meets the identified
requirements to solve the problem
Schedule Feasibility Correct answer-measures the project time frame to ensure it can completed
on time
Technical Feasibility Correct answer-measures the practicality of a technical solution and the
availability of technical resources and enterprise, is the technology available and easy enough to use
Gap Analysis Correct answer-the comparison of actual performance with potential or desired
performance with potential or desired performance
How do we move from the current state to the desired state
eBusiness Model Correct answer-o Relationship
