Part 1 Assignment: What is a Database Professional, and What Do Database Professionals Do?

Purpose

In this assignment, you will explore the Data Base Life Cycle (DBLC) and compare it with the more general Systems Development Life Cycle (SDLC). Additionally, in this unit’s Assignment, you will explore the career of a database professional and select a type of database professional in order to describe their professional functions, obligations, and reporting structure.

Assignment Instructions

This Assignment includes a written component and a practical component.

Part 1: SDLC Cycle

Write a 300–400 word response reviewing the Systems Development Life Cycle (SDLC) and Database Life Cycle (DBLC) and how the DBLC fits within the SDLC. Please provide references to support your response. The items below should be addressed.

Define the term SDLC.
Define the term DBLC.
Define how the DBLC fits within the SDLC.

Part 2: Career Roles

Select a database career role (i.e., database developer, database designer, database administrator, database analyst, database architect, database consultant, database security officer, or data manager). Write a 300–400 word summary defining this role. Please provide references to support your response. The items below should be addressed.

Define the role within an organization (i.e., Who does this role report to? Who does this role oversee?).
Define the tasks that this role performs.
Provide a job advertisement for this role.
Assignment Requirements

Your paper should be 2–3 pages in length. Be sure to use appropriate APA format and cite your textbook or other sources that you used in your paper.

The paper should contain sufficient information to adequately answer the questions and contain no spelling, grammar, or APA errors. Points deducted from grade for each writing, spelling, or grammar error are at your instructor’s discretion.

Written work should be free of spelling, grammar, or APA errors. Points deducted from grade for each writing, spelling or grammar error are at your instructor’s discretion.

For more information on APA style formatting, go to Academic Writer under Academic Tools of this course.

Also review the university policy on plagiarism. If you have any questions, please contact your instructor.

Review the rubric before beginning this activity.

Part 2 Assignment: Entity-Relationships (ER) Modeling Concepts and Application

Purpose

This Assignment will assess your comprehension of key database terms, application of foreign and primary key placement, and development of entity-relationships models that match provided database design scenarios.

Assignment Instructions

Part 1: Definitions

Define each of the following terms. In addition, provide an example of each term.

Business rule
Entity set (entity type)
Entity instance
Attribute
Relationship
Connectivity
Cardinality constraint
Primary key
Foreign key
Associative entity

Part 2: Business Rules

Please use this four-row format when writing your connectivity-determining business rules.

Figure 1. Publisher Database

Figure shows an Entity-Relationship (ER) model with five tables and the connecting relationships. The five tables include: Book, Author, Publisher, Country, and Volume.

Explanation of each row in the 4-row format:

Write the entity pair. Underline and/or bold.
Give one business rule. Indicate the multiplicity of that rule in parentheses.
Give the other business rule. Indicate the multiplicity of that rule in parentheses.
Give the connectivity. (If the connectivity is M:N, give the associative entity name.)
Following is an example of the required four-row format for business rules for a binary relationship for this Assignment.

Example:

Publisher – Book

ONE Publisher may publish MANY Books [M]

ONE Book has ONE Publisher [1]

Publisher 1:M Book.

Complete the same 4-row format for the remaining relationships in the ERD illustrated in Figure 1.

Be sure the connectivity row (row 4) for each 1:M relationship has the correct direction. The rule with the multiplicity “many” will determine the direction. For example, if the rule is: “ONE Publisher may publish MANY Books,” then Publisher is the “1” table and Book is the “M” table, so you would write the connectivity as: Publisher 1:M Books.

Use the four-row format to write the business rules and connectivity for each of the four binary relationships other than Publisher-Book in the enterprise data model pictured above in Figure 1.

Part 3: Primary Key/Foreign Key Placement

The primary key (PK) of a table is often named after the table. Example: ISBN-13 is chosen as the name of the primary key for the Book table; PublisherID is the PK of the Publisher table.

For each entity set in the table below, give the primary key attribute(s) and the foreign key attribute(s) (if any).

Entity Set

Primary Key Attribute(s)

Foreign Key Attribute(s)

Publisher

Volume

Book

Book-Author

Author

Country

Hint 1 – There may not be a foreign key attribute if the entity is not on the “M” side of a relationship.

Hint 2 – One entity type in the above table is not shown in Figure 1.

Part 4: Entity Relationship Diagram

Update the ERD from Question 2 to account for the M:N relationship between Book and Author. Start with the diagram in IT 525 — Part 2 – Publisher Q4A. Also, review the IT 525 – Part 2 — Visio Tutorial.

Part 5: Entity Relationship Diagram Including Review of Books by Customers Scenario

The report form below shows the fields to identify the review of books by customers. Follow either the top-down database design or the bottom-up database design approach to extend the ERD from Question 2. Provide the new ERD. Include a 4–6 sentence paragraph describing how you chose the approach you used to extend the ERD and the process followed.

An entity set table showing Primary and Foreign Key Attributes.

Figure shows an Entity-Relationship (ER) model with five tables and the connecting relationships. The five tables include: Book, Author, Publisher, Country, and Volume.

Customer ID:

Customer Name:

Review Date

Book ISBN

Book Title

Rating of Book

Customer Review

1/12/2013

…

…

…

…

1/15/2013

…

…

…

…

Assignment Requirements

Be sure to use appropriate APA format and cite your textbook or other sources that you used in your paper.

The paper should contain sufficient information to adequately answer the questions and contain no spelling, grammar, or APA errors. Points deducted from grade for each writing, spelling, or grammar error are at your instructor’s discretion.

For more information on APA style formatting, go Academic Writer under Academic Tools of this course.

Also review the university policy on plagiarism. If you have any questions, please contact your instructor.