Database
Analysis, Design and Implementation
Unit
3 – Discussion Board
Top
of Form
View Assignment
Details for Unit 3 – Discussion Boardas
PDF
Bottom
of Form
Assignment
Overview
Type: Discussion
Board
Unit: Database
Performance Considerations
Due
Date: Tue,4/28/20
Grading
Type: Numeric
Points
Possible: 75
Points
Earned: not
available
Deliverable
Length: 2 parts; see assignment details
View
objectives for this assignment
Go
To:
-
Assignment
Details -
Scenario
-
Learning
Materials -
Reading
Assignment
My
Work:
Online
Deliverables:
-
Discussion
Board
Looking
for tutoring? Go
to Smarthinking
Assignment
Details
Assignment
Description
Primary
Discussion Response is due by Friday (11:59:59pm Central), Peer
Responses are due by Tuesday (11:59:59pm Central).
Primary
Task Response: Within
the Discussion Board area, write 400–600 words that respond to the
following questions with your thoughts, ideas, and comments. This
will be the foundation for future discussions by your classmates. Be
substantive and clear, and use examples to reinforce your ideas.
Indexes
used in databases can speed up searches for information, but if they
are not carefully created, they can have a negative impact on
database performance.
Research
all of the following online, and discuss them in your posting:
-
What
is the general purpose of indexing in a database? -
Discuss
the different types of indexes used and the related impact of each
on the performance of the database system. -
What
is the impact of creating indexes on foreign keys that are used in a
relationship that enforces referential integrity? -
What
is the impact of creating too many indexes on one table?
Be
sure to support your information by citing at least 2 references
using APA format.
The post Database Analysis, Design and Implementation appeared first on My Assignment Online.