PREMIUM EXAM PREP VERIFIED QUESTIONS
AND ANSWERS A+
◉ Attribute. Answer: the data elements associated with an entity
Ex: first name, last name, zip code, phone number = field
◉ Stored Attribute. Answer: the actual attribute stored in the DBMS,
used to derive other attributes
◉ Derived Attribute. Answer: calculated using the value of another
attribute
Ex: stored = DOB derived = current date - DOB (age)
◉ Entity Relationship Diagram. Answer: shows the relationship of entity
sets stored in a database
◉ One to one (1:1). Answer: the airport is in one town and the town only
has one airport
◉ One to many (1:M). Answer: ex: one customer can make many
orders, the order can contain many items
,◉ Many to many (M:M):. Answer: ex: many customers can order the
same item
◉ Primary Key. 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. 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. Answer: Project: a temporary activity a company undertakes
to create a unique product, service or result
◉ Scope. Answer: what the product will include, what problem is being
solved, justifications, requirements, and boundaries
◉ Scope Creep. Answer: when scope grows without budget and
schedule also growing
◉ Milestones. Answer: points in time at which a task will be done
, ◉ Task Sequencing. Answer: designing the tasks to leverage your team,
and get the projects done as quickly as possible (PERT chart, Gantt
Chart)
◉ PERT chart. 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. Answer: the path that takes the leads amount of time to
complete (minimum time). The critical path has no slack
◉ Slack Time. 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. Answer: o Takes too long
o Costs too much
o Wrong scope functionality
◉ System Development Life Cycle (SDLC). Answer: The overall
process for developing information systems, from planning and analysis,
through implementation