ISYS389 DU Ch 1 Database Environment & Development Process Project ISYS 382 This assignment is an extension of Problem 5 in Chapter 1, which you might rem

ISYS389 DU Ch 1 Database Environment & Development Process Project ISYS 382

This assignment is an extension of Problem 5 in Chapter 1, which you might remember was part of Assignment 1. In this case, however, the entities of the AIS student organization are provided for you below. Your task is in TWO parts:

1. Using Visio, and following the techniques in Chapter 2, create an ERD showing all of the entities, attributes, relationships and cardinalities. Be sure to label everything, including the relationships.

2. Using Visio, and following the techniques in Chapter 3, create an enhanced (hierarchical) ERD showing the supertypes and subtypes that can be inferred from the diagram in part 1. Be sure to place all of the attributes and relationships in the proper locations. Label everything, including the Completeness and Disjointness constraints. Also be sure to include any subtype discriminators.

****Put both diagrams in one Visio file on separate pages.

Part 1 should be on page 1.

Part 2 should be on page 2. (You can add another page by clicking the “+” at the bottom of the window where the page tabs are.)

AIS Student Organization Entities:

? Student ? Professor ? Recruiter (Company) ? Recruiter Contact (Individual) ? Meeting ? Event ? Dues Collected hp
9
he exc
y May
aese file
produs
ecause
Chapter 1 . The Database Environment and Development Process
information must be recorded and retained. CUSTOMER and ORDER are entities in
Figure 1-3a. The data you are interested in capturing about the entity (e.g., Customer
Name) is called an attribute, Data are recorded for many customers. Each customer’s
information is referred to as an instance of CUSTOMER.
applica
outside
unting
do De
RELATIONSHIPS A well-structured database establishes the relationships between enti-
ties that exist in organizational data so that desired information can be retrieved. Most
relationships are one-to-many (1:M) or many-to-many (M:N). A customer can place (the
Places relationship) more than one order with a company. However, each order is usu-
ally associated with (the Is Placed By relationship) a particular customer. Figure 1-3a
shows the 1:M relationship of customers who may place one or more orders; the
1.M nature of the relationship is marked by the crow’s foot attached to the rectangle
(entity) labeled ORDER. This relationship appears to be the same in Figures 1-3a and
1:36. However, the relationship between orders and products is M?N. An order may be
h new
new
N pro-
FIGURE 1-3 Comparison of
enterprise and project-level
data models
(a) Segment of an enterprise
data model
paced
orma
CUSTOMER
Places
Cres
I file
em’s
ons
ton
Is Placed By
ase
ni-
ORDER
ing
Contains
Is Contained in
PRODUCT
(b) Segment of a project data
model
CUSTOMER
Customer ID
Customer Name
PRODUCT
Product ID
Standard Price
Places
Has
Is For
Is Placed By
ORDER
Order ID Contains
Customer ID
Order Date
ORDER LINE
Is Contained in Quantity
Loon
39
Aata
lo
cover
sen
6.
Chapter 1 . The Database Environment and Development Process
3. Contrast the following terms
a data dependence; data independence
14. Are there procedures and processes that are common to
b. structured data; unstructured data
the use of SDLC, prototyping, and agile methodologies?
c data; information
Explain any that you can identify and then indicate why the
d. repository; database
methodologies are considered to be different even though
e entity; enterprise data model
fundamental procedures and processes are still included.
f. data warehouse; ERP system
15. Explain the differences between user views, a conceptual
g. two-tier databases; multitier databases
schema, and an internal schema as different perspectives of
h. systems development life cycle; prototyping
the same database.
1. enterprise data model; conceptual data model
16. In the three-schema architecture:
1. prototyping: agile software development
a. The view of a manager or other type of user is called the
schema.
4. List five disadvantages of file processing systems.
5. List the nine major components in a database system
b. The view of the data architect or data administrator is called
the schema
environment
are relationships between tables expressed in a rela-
C. The view of the database administrator is called the
tional database?
schema
7. What does the term data independence mean, and why is it an
17. Revisit the section titled “Developing a Database
Application for Pine Valley Furniture Company.” What
important goal?
10 potential benefits of the database approach over con-
phase(s) of the database development process (Figure 1-8)
ventional file systems.
do the activities that Chris performs in the following
9. List five costs or risks associated with the database approach.
sub-sections correspond to:
a. Project planning
10. Define a three-tiered database architecture.
b. Analyzing database requirements
11. In the three-tiered database architecture, is it possible for c Designing the database
there to be no database on a particular tier? If not, why? If
d. Using the database
yes, give an example.
e Administering the database
12. Name the five phases of the traditional systems develop- 18. Why might Pine Valley Furniture Company need a data
ment life cycle (SDLC), and explain the purpose and deliv-
warehouse?
erables of each phase.
19. As the ability to handle large amounts of data improves, de-
13. In which of the five phases of the SDLC do database devel- scribe three business areas where these very large databases
opment activities occur?
are being used effectively.
8. List 10
Problems and Exercises
1. For each of the following pairs of related entities, indicate
whether (under typical circumstances) there is a one-to-
many or a many-to-many relationship. Then, using the short-
hand notation introduced in the text, draw a diagram for
each of the relationships.
a. STUDENT and COURSE (students register for courses)
b. BOOK and BOOK COPY (books have copies)
c. COURSE and SECTION (courses have sections)
d. SECTION and ROOM (sections are scheduled in rooms)
e. INSTRUCTOR and COURSE
2. Reread the definitions for data and database in this chap-
ter. Database management systems only recently began to
include the capability to store and retrieve more than nu-
meric and textual data. What special data storage, retrieval,
and maintenance capabilities do images, sound, video, and
other advanced data types require that are not required or
are simpler with numeric and textual data?
Table 1-1 shows example metadata for a set of data items.
Identify three other columns for these data (i.e., three other
metadata characteristics for the listed attributes) and com-
plete the entries of the table in Table 1-1 for these three ad-
ditional columns.
4 In the section “Disadvantages of File Processing Systems,”
the statement is made that the disadvantages of file process-
ing systems can also be limitations of databases, depending
on how an organization manages its databases. First, why
do organizations create multiple databases, not just one
all-inclusive database supporting all data processing needs?
Second, what organizational and personal factors are at
work that might lead an organization to have multiple, in-
dependently managed databases (and, hence, not completely
follow the database approach)?
5. Consider a student club or organization in which you are a
member. What are the data entities of this enterprise? List
and define each entity. Then, develop an enterprise data
model (such as Figure 1-3a) showing these entities and im-
portant relationships between them.
6. A driver’s license bureau maintains a database of licensed
drivers. State whether each of the following represents data
or metadata. If it represents data, state whether it is struc-
tured or unstructured data. If it represents metadata, state
whether it is a fact describing a property of data or a fact
describing the context of data.
a. Driver’s name, address, and birth date
b. The fact that the driver’s name is a 30-character field
c. A photo image of the driver
d. An image of the driver’s fingerprint
e. The make and serial number of the scanning device that
was used to scan the fingerprint
f. The resolution (in megapixels) of the camera that was
used to photograph the driver
8. The fact that the driver’s birth date must precede today’s
date by at least 16 years
7. Great Lakes Insurance would like to implement a relation
al database for both its in-house and outside agents. The
lop-
eliv-
18. Why might Pine Valley Furniture
warehouse?
19. As the ability to handle large amounts of data improves,
de-
scribe three business areas where these very large databases
are being used effectively.
vel-
ate
CO-
rt-
or
–
–
1
all-inclusive database supporting all data processing needs?
Second, what organizational and personal factors are at
work that might lead an organization to have multiple, in-
dependently managed databases (and, hence, not completely
follow the database approach)?
5. Consider a student club or organization in which you are a
member. What are the data entities of this enterprise? List
and define each entity. Then, develop an enterprise data
model (such as Figure 1-3a) showing these entities and im-
portant relationships between them.
6. A driver’s license bureau maintains a database of licensed
drivers. State whether each of the following represents data
or metadata. If it represents data, state whether it is struc-
tured or unstructured data. If it represents metadata, state
whether it is a fact describing a property of data or a fact
describing the context of data.
a. Driver’s name, address, and birth date
b. The fact that the driver’s name is a 30-character field
c. A photo image of the driver
d. An image of the driver’s fingerprint
e. The make and serial number of the scanning device that
was used to scan the fingerprint
f. The resolution (in megapixels) of the camera that was
used to photograph the driver
g. The fact that the driver’s birth date must precede today’s
date by at least 16 years
7. Great Lakes Insurance would like to implement a relation-
al database for both its in-house and outside agents. The
r

Purchase answer to see full
attachment