DBM/380 Database Concepts

The Vice President of Sales for your company has asked you for more information on cloud-based office productivity suites. He tells you that the Sales team is often remote and needs to be able to stay connected to the office.     

DBM380 DATABASE DESIGN DBM380 Write a 1- to 2-page paper about a database application for the following scenario:
You work at an Art Museum that needs to track the artwork, artists, and locations where the art is displayed or stored within the museum.
DBM380 Write a 700- to 1,050-word informal paper using Microsoft Word in which you address the following:
• Accurately definethe terms "database system" and "relational database architecture".
DBM380 Write a 1- to 2-page paper about a database application for the following scenario:
You work at an Art Museum that needs to track the artwork, artists, and locations where the art is displayed or stored within the museum.
DBM/380 SPARKLE DIAMOND DATABASE

DBM/380 WEEK 1

Everything listed for this week is included in purchase!

 

Individual: Database Environment Proposal

Option#1: Art Museum Paper = 883 Words!(5 pages)

Option#2: Art Museum Paper = 498 Words! (4 pages)

Option#3: Art Museum Paper = 420 Words! (3 pages)

W1 - Ind: Database Environment Proposal
As one of the program outcomes for the Bachelor of Science in Information Technology program, students must design and develop a database using professional principles and standards.
Write a 2-3 page paper using the following information:
Topic: Make up an Art Museum that needs to track the artwork, artists, and locations where the art is displayed or stored within the museum.
Subjects to Cover:
   1. Analyze the database environment.
   2. Describe the problems and constraints.
   3. Describe the objectives of the database environment.
   4. Describe the scope and boundaries.
   5. List the data specifications (must include a minimum of three entities with attributes).
Additional Comments:
    1. Include 2 or 3 references.
    2. Format the paper and citations using APA format.
    3. Submit your assignment using the Assignment Files tab.
Note: The database chosen will be used in the Week Two through Five
Individual Assignments.

 

Week 1 Supporting Activity Questions

NOTE: Class questions change depending on which Instructor you have, so these questions below may not match exactly.

 

Supporting Activity: Relational Database Architecture Best Practices
Research a current article describing relational database architecture best practices.
Share and discuss the article with the class.
Include the following in your discussion:
    • What is meant by relational database architecture
    • How the author(s) define relational database architecture in the article

 

Supporting Activity: Database Systems

Write a 200- to 300-word short-answer response for the following:

Reflect on the textbook readings. Using the search strings listed in the Electronic Reserve Readings for Week one search for additional information on database systems. What information would your provide to an organization or your employer on why database systems should be used?

 

Supporting Activity: Unstructured and Structured Data

Write a 200- to 300-word short-answer response for the following:

Reflect on the textbook readings. Use examples to compare and contrast unstructured and structured data. Which type is more prevalent in a typical business environment?

 

Supporting Activity:Limitations With Non-relational Structures

Write a 200- to 300-word short-answer response for the following:

What limitations have you or someone you know encountered in the past in using non-relational structures (such as in a Microsoft Excel or Word file) to store data? What were the advantages?

 

 

***BONUS ASSIGNMENTS INCLUDED WITH PURCHASE***

 

Individual: Database Selection Paper

Word Count: 1,114 words = A+ Work!

Write a 700- to 1,050-word informal paper using Microsoft Word in which you address the following:
Accurately definethe terms "database system" and "relational database architecture".
• In your Learning Team next week, you will have a defined application for a database

    that you will construct together, but this week, think about what you personally could

    use a database for in your personal life. Choose a subject from your work/home/hobby

    that requires the keeping of multiple records; e.g., music collections, sales records,

    inventory. You will not be creating this database in this course, but will use the idea this

    week to practice the skills required to take an idea into the planning of a database.
Completely define the objectives for the database application that would provide a

    solution for your record keeping requirements.
List the data specifications (must include a minimum of three entities with attributes).
List at least two constraints and assumptions for your solution.
Describe at least two basic database functions that a spreadsheet cannot perform.
Accurately explain why a relational database management system would offer the

    most robust solution for your requirements.
Include two or three references.
Format your paper and citations using APA format.
Submit your assignment to the Assignment Files tab

 

Individual: Database Design Paper
Write a 350- to 700-word paper in which you do the following:
• Explain what database systems are and how they are used.
• Define database architecture. Consider Microsoft Access, Microsoft SQL Server, Oracle, and IBM DB2 software as possible examples.
• Summarize your paper by describing the database systems in your workplace, identifying which database systems and architecture they fall under.
Include 2 to 4 references.
Format your paper consistent with APA guidelines.

 

DBM/380 DATABASE DESIGN DBM380 Write a 1- to 2-page paper about a database application for the following scenario:
You work at an Art Museum that needs to track the artwork, artists, and locations where the art is displayed or stored within the museum.
SMALLMART DATABASE PROPOSAL
DBM/ 380 The following assignment is based on the database environment proposed in the Week One Individual Assignment. Perform a logical design on the proposed database environment without going through the full normalization process. Include the identification of all entities and attributes associated with the environment.
DBM/ 380 Build a 1-page Entity Relationship Diagram that models the required tables and relationships using Microsoft Visio, Lucidchart, or another software tool of your choice. 

The table design and relationships must support the following functionality:

DBM/380 WEEK 2

 

Everything listed for this week is included in purchase!

 

Learning Team: Status Update & ERD Diagram - Sparkle Diamonds

1st Draft of ERD Diagram included in purchase! A+ Work! Includes a Fully Editable MS Visio file PLUS 800-word Summary included with purchase!

What needs to be performed:
Start/continue working on your Learning Team Database and Presentation described in Week 5.
What needs to be submitted:
Submit a status update paper for your Learning Team. Please include two or three paragraphs that describe the work you have completed this week.
Additional Comments:
1. Format the paper and citations using APA format.
2. Submit your assignment using the Assignment Files tab.
Recommendations:
To ensure the team is on track, it is highly recommended that the team completes the following during this week: Create a first draft of the ERD due in week 5.

 

Individual: Database Design and ERD Creation - Art Museum

Option#1: Art Museum (includes MS Visio ERD Diagram)

Option#2: Art Museum (includes Visio ERD Diagram & Logical Design)

2 Fully editable Microsoft Visio ERD Diagrams INCLUDED!

Notes:
1. The following assignment is based on the database environment used in the Week One Individual Assignment.
What needs to be performed:
1. Create a detailed ERD (without yet going through the full normalization process) using the data specifications from the logical design.
2. Create a 1-3 page paper to document your logical design including the process you went through. Discuss the process you went through to select the appropriate data types, primary and foreign keys, and other constraints that are necessary to maintain the integrity of the database.
Software to be used:
You can use Microsoft Visio or another tool to create this diagram.
One alternative is to create a free account to access LucidChart, a Visio compaible tool (www.lucidchart.com).
Additional Comments:
1. Format the paper and citations using APA format.
2. Submit your assignment using the Assignment Files tab.
3. Submit the ERD as a Visio file or PDF please.

 

Week 2 Supporting Activity Questions

NOTE: Class questions change depending on which Instructor you have, so these questions below may not match exactly.

 

Supporting Activity: Null Value

Write a 200- to 300-word short-answer response for the following:

Think of a situation where null value should be allowed and a situation where it should not be allowed. What are the consequences of inappropriate null settings?

 

Supporting Activity: Many-To-Many Relationship

Write a 200- to 300-word short-answer response for the following:

What are some issues when working with a many-to-many relationship? Provide some examples. 

 

Supporting Activity: Database Designer

Write a 200 - to 300-word short-answer response for the following:

How must a database designer balance the time to complete data modeling steps with the benefits the data modeling process offers in creating a database? Consider examples from your work place and class assignments. 

 

Supporting Activity: Data Types

Write a 200- to 300-word short-answer response for the following:

• Why it is necessary to choose appropriate data types for each data column?

 

***** BONUS FILES INCLUDED IN PURCHASE *****

 

Learning Team - SmallMart Database Proposal Memo

Word Count: 685 words!

Start working on your Learning Team Database and Presentation outlined in Week One with delivery in Week Four and Five. Begin by analyzing the requirements provided in the Learning Team Database and Presentation Overview from the first week.

 

Individual: Smith Consulting Database Environment Paper

Write a 750- to 1,050-word paper in which you complete the following:

Choose a database environment from the following: Smith Systems Consulting (Virtual Organization) – needs a database to track their consulting staff, each staff member’s skill sets, and what projects they are working on.

• Analyze the database environment.

• Describe the problems and constraints.

• Describe the objectives of the database environment.

• Describe the scope and boundaries.

• List the data specifications (must include a minimum of three entities with attributes). Include 3 to 5 references.

 

DBM/380 Database Normalization Paper
DBM/380 Database Normalization Paper
DBM/380 Week 3 

Individual: Database Normalization

Historical Art Museum paper includes Logical Design of Database and ERD in Crows Feet notation that is normalized to 3NF = A+++ Work!
DBM/380 NORMALIZATION In your Learning Team this week,you normalized the ERD to third normal form (3NF). This is a key element in effective database design.
For this assignment, write a 350- to 700-word informal paper using Microsoft Word explaining how to normalize a database to 3NF.

DBM/380 Week 3

Everything listed for this week is included in purchase!

 

Learning Team: Status Update (SQL Tables included) Sparkle Diamonds

Microsoft Visio Diagram Included of Normalized Sparkle Diamonds database!

What needs to be performed:
Start/continue working on your Learning Team Database and Presentation described in Week 5.
What needs to be submitted:
Submit a status update paper for your Learning Team. Please include two or three paragraphs that describe the work you have completed this week.
Additional Comments:
1. Format the paper and citations using APA format.
2. Submit your assignment using the Assignment Files tab.
Recommendations:
To ensure the team is on track, it is highly recommended that the team completes the following during this week:
1. If not done in week 2, normalize your tables and update your ERD.
2. Using the MySQL Workbench, or through a script, construct the tables in MySQL from the logical database design from your normalized ERD.
3. Populate each table with at least ten data records that would support the user's functional requirements.

 

 

Individual: ERD Normalization - Art Museum
Notes:
1. The following assignment is based on the database environment used in the Week One and Two Individual Assignments.
2. What is turned in this week should be used for the week four and five assignments, assuming no corrections/additions are required.
3. There is no paper for this assignment, just the normalized ERD.
What needs to be performed:
1. Take the ERD from week two and build upon it, if the ERD provided in week two already meets the requirement then it can be re-used as is.
2. Build upon the original three tables (art/artwork/location), so that there will end up being more than the original three tables.
3. Fully normalize the ERD so that it meets 3NF requirements.
Software to be used:
You can use Microsoft Visio or another tool to create this diagram. One alternative is to create a free account to access LucidChart, a Visio compaible tool (www.lucidchart.com).
Additional Comments:
1. Submit your assignment using the Assignment Files tab.
2. Submit the ERD as a Visio file or PDF please.

 

 

Included Week 3 Supporting Activity Questions

NOTE: Class questions change depending on which Instructor you have, so these questions below may not match exactly.

 

Supporting Activity: DBMS and Data Mining

Write a 200- to 300-word short-answer response for the following:

A motor vehicle maintenance center wants to improve its services by using database management systems (DBMS) and data mining. What tables are needed in such a database and how can it help improve their 2.2, 3.2services?

 

Supporting Activity: Cardinality Constraints

Write a 200- to 300-word short-answer response for the following:

What are four types of cardinality constraints? Provide personal examples of each.

Note . The examples from the textbooks cannot be used for this question.

 

Supporting Activity: Primary Key

Write a 200- to 300-word short-answer response for the following:

How do you select the primary key from the candidate keys? How do foreign keys relate to candidate keys? Provide examples from either your workplace or class assignments.

 

Supporting Activity: Overall Design

Write a 200- to 300-word short-answer response for the following:
Under what circumstances would you break down an overall design to include individual user views? Provide examples from either your workplace or class assignments.

 

 

***** BONUS FILES INCLUDED IN PURCHASE *****

 

SmallMart ERD Diagram (Visio Diagram included!)
Continue working on your Learning Team Database and Presentation due in Week Four. Design your database including the creation of an ERD, identifying primary and foreign keys, determining the appropriate types for database attributes, determining necessary constraints, and normalizing the database to at least the 3rd Normal Form. Use the logical database design to create the physical database. Populate the database with test data using the requirements outlined in Week One.
Tutorial includes part of the Final Team Project including a Fully Editable MS Visio ERD Diagram of SmallMart Database along with a 7-page paper identifying primary and foreign keys, data types and attributes, constraints, etc. for the SmallMart Database.

 

 

DBM/380 Sparkle Diamond Database Week 4 Database Construction PowerPoint
DBM/380 WEEK 4 Submit a .sql file that includes all of the scripts to create the database tables, establish keys and constraints, populate data within the database, and queries to the Assignment Files tab.
DBM/380 WEEK 4 Submit a .sql file that includes all of the scripts to create the database tables, establish keys and constraints, populate data within the database, and queries to the Assignment Files tab.
DBM/380 Sparkle Diamond Database Week 4 Database Construction PowerPoint

DBM/380 Week 4

Everything listed for this week is included in purchase!

 

Learning Team: Status Update & MySQL Queries - Sparkle Diamonds
What needs to be performed:
Start/continue working on your Learning Team Database and Presentation described in Week 5.
What needs to be submitted:
Submit a status update paper for your Learning Team. Please include two or three paragraphs that describe the work you have completed this week.
Additional Comments:
1. Format the paper and citations using APA format.
2. Submit your assignment using the Assignment Files tab.
Recommendations:
To ensure the team is on track, it is highly recommended that the team completes the following during this week: Complete the queries for the team project.

 

 

Individual: Database Creation - Art Museum
Notes:
1. The following assignment is based on the database environment used in the week one, two and three individual assignments.
2. There is no paper or ERD for this assignment, just the database file (.sql file that includes the table CREATE and record INSERT statements).
3. Take the ERD from week three and turn it into a MySQL database.
What needs to be performed:
1. The database should be fully normalized.
2. The Fields/Columns should have appropriate data types.
3. The primary Keys should be established.
4. The database tables must be able to be imported into MySQL.
5. The database records must be able to be imported into MySQL.
6. Each of the main tables should have at least ten records include.
Software to be used:
MySQL must be used.
Additional Comments:
1. Submit your assignment using the Assignment Files tab.
2. Submit the ERD as a Visio file or PDF please.

 

Week 4 Supporting Activity Questions

NOTE: Class questions change depending on which Instructor you have, so these questions below may not match exactly.

 

Supporting Activity: Normalization Process

Write a 200- to 300-word short-answer response for the following:

• In your own words, describe the nature and purpose of the normalization process.

    Provide some examples from sources other than the readings

 

Supporting Activity: Disadvantage of Normalizing

Write a 200- to 300-word short-answer response for the following:

• Discuss the disadvantages of normalizing a database to a high degree of

   normalization. Should there be a definite rule on when to stop normalizing? Provide

    some examples from sources other than the readings.

 

Supporting Activity: Denormalization

Write a 200- to 300-word short-answer response for the following:

 • In what business database environments is denormalization appropriate and why?

     What would denormalization specifically involve?

 

***** BONUS FILES INCLUDED WITH PURCHASE *****

 

Learning Team: Week Four Deliverable

SmallMart Database Project

Your team has been asked by a small retail client, SmallMart, to create the underlying database for a new point of sale (POS) system. You will be going through the Database Development Life Cycle, beginning with the analysis of requirements and ending with the creation of a physical database, the creation of queries that will be used in reporting, and a presentation that will be delivered to the CEO of SmallMart.

Tutorial Includes:

1. SmallMart Database 9-page Paper (2 Options)

2. Physical Access Database for SmallMart (2 Options)

3. SQL Queries

4. PowerPoint Presentation to the CEO of SmallMart (2 Options)

5. SmallMart MS Visio ERD Diagram (fully editable!)

 

 

 

DBM/380 WEEK 2 SQL QUERIES DBM380 DBM/380 Week 5 Learning Team: Week Five Deliverable
Create a 5- to 7-slide Microsoft PowerPoint Presentation in which you explain the principles of database management and make recommendations for continued management of the database you created in your learning team project.
Include at least three external sources as a part of your research.
DBM380 DBM/380 Week 5 Learning Team: Week Five Deliverable
Create a 5- to 7-slide Microsoft PowerPoint Presentation in which you explain the principles of database management and make recommendations for continued management of the database you created in your learning team project.
Include at least three external sources as a part of your research.
Your team has been chosen to develop and design an inventory management system for Sparkle Diamonds, Inc. Sparkle Diamonds (SD) is headquartered in Phoenix, AZ, and is a large wholesale distributor of high quality diamonds to retailers throughout the United States.
DBM/380 WEEK 5 DATABASE AND PRESENTATION SPARKLE DIAMONDS

DBM/380 Week 5

 

Everything listed for this week is included in purchase!

Learning Team: Database and Presentation

Your team has been chosen to develop and design an inventory management system for Sparkle Diamonds, Inc. Sparkle Diamonds (SD) is headquartered in Phoenix, AZ, and is a large wholesale distributor of high quality diamonds to retailers throughout the United States. Diamond retailers purchase diamonds from SD based on the carat, clarity, cut, and color of the diamond and usually purchase multiple diamonds on the same order. The sales team at SD is looking for a database management system (DBMS) that will allow them to query their existing diamond inventory and prepare a sales order for their customers. Their customers are very specific with their purchasing needs and the DBMS must capture and maintain the data about Sparkle Diamonds' customers, inventory, and orders.
What needs to be performed:
    1. Create a single MySQL .sql file containing all create and insert commands that can

         be imported.
    2. Create an ERD, which should be included inside your presentation.
    3. Create a 7-10 slide PowerPoint presentation.
Include the following specifications in your database:
    1. The database must support the following: customers, inventory, and customer

         orders.
*  Customers: Each customer is assigned a unique customer number but may have

    multiple locations to ship to.
*  The sales team needs to be able to select the customer and a shipping location from

    multiple locations for the customer, for preparing sales orders.
*  Inventory: The sales team will want to query the inventory to find diamonds that meet

    the following specifications of their customers: Cost, Price, Carat, Clarity, Cut, and

    Color.
*  The sales team needs be able to determine if items are in stock or not.
*  The diamond clarity needs to be selectable based on the specific criteria listed below.
*  The diamond cut needs to be selectable based on the specific criteria listed below.
*  The diamond color needs to be selectable based on the specific criteria listed below.
Orders: The sales team will want to prepare a sales order for existing customers and make sure they are selling only diamonds that are in inventory.
*  The DBMS must be designed such that customers can purchase multiple diamonds on

    one sales order.
    2. Each of the tables must include a primary key, appropriate fields and the fields

    should have appropriate data types.
    3. The overall database must be normalized to 3rd Normal Form.
    4. The database will need to be populated with test data. At least ten records for

    each of the main tables and the sub-tables should contain the appropriate field

    specified below.
    5. The following queries need to be created and there purpose should be clearly

    identified.

      A single query reporting an inventory list showing all the attributes for each diamond

      in inventory (both in stock and not in stock).
      A single query reporting the total price and cost for all inventory currently in stock.
      A single query reporting all diamonds in stock and have a carat weight over 1.0

      carats.
      A single query reporting customer names and order numbers for all orders placed in

      the past twelve months.
      A single query reporting customer names and order numbers and all items on each

      order.

Include the following specifications in your presentation:
      1. The normalized ERD.
      2. How normalization was approached.
      3. Any decisions that were made around keys, data types, constraints, etc.
      4. Considerations that were made around the creation of the physical database
      5. The value the queries created provide.

Additional Details about the database:
HINT: The three main tables will require sub-tables that are associated to the main table.
Customer: Should have a customer number, name, etc and have the ability to have multiple shipping addresses.
Inventory: Should cover cost, price, carat, clarity, cut, and color

Clarity Options
IF: Internally Flawless
VVS1: Very, very slightly included (pavilion)
VVS2: Very, very slightly included (crown)
VS1: Very slightly included (under 10X magnification)
VS2: Very slightly included (to the naked eye)

Color Options:
D: Colorless - can be detected only by a gemologist in side by side comparisons, and rarely by the untrained eye
E: Colorless - can be detected only by a gemologist in side by side comparisons, and rarely by the untrained eye
F: Colorless - can be detected only by a gemologist in side by side comparisons, and rarely by the untrained eye
G: Near Colorless - color rated by a gemologist
H: Near Colorless - rated by a gemologist

I: Near Colorless - rated by a gemologist
J: Near Colorless - rated by a gemologist
K: Near Colorless - rated by a gemologist

Cut Options:
E : Excellent
VG: Very Good
G : Good

Orders: Should cover order information and have the ability to have multiple items included in a single order.

Additional Comments:
1. A MySQL .sql file needs to be submitted and it should create the database, tables and records.
2. A separate file needs to be submitted and contain the SQL statements to run queries against the database submitted.
3. Submit the .sql file, presentation and SQL statements to the Assignment Files tab

 

 

Individual: SQL Queries
The following assignment is based on the database environment created in the Week Four Individual Assignment.
Design and develop the below queries using professional principles and standards:
• A set of SQL Statements that returns all rows and all data for each table in your database
• Two SQL Statements that return a subset of columns and a subset of rows using the WHERE clause
• Two SQL Statements that join two or more tables in one query. Look for primary and foreign keys to help you determine join points. Use the JOIN clause as a part of your queries

As a part of the Week Five assignment, it is important to resubmit work completed in Weeks One through Five for a complete project review. Note: Week One through Five is not included in this Tutorial Purchase - ONLY the requirements for Week 5 are included.
You should make any necessary improvements based on faculty feedback received to the documents in Weeks One through Four before submitting.

 

Week 5 Supporting Activity Questions

NOTE: Class questions change depending on which Instructor you have, so these questions below may not match exactly.

 

Supporting Activity: Database Administrator and Architect

Write a 200- to 300-word short-answer response for the following:

•  Describe the differences between a database administrator and a database

     architect. How is your organization structured to handle the functions of these roles?

 

Supporting Activity: Database Service

Write a 200- to 300-word short-answer response for the following:

•  Locate a hosted, distributed database service. Explore its features and talk about your

     experiences. In what situations would an organization consider using it?

 

Supporting Activity: DBMS

Write a 200- to 300-word short-answer response for the following:

•  Describe the advantages and disadvantages of DBMS-provided security. Compare it

     to network or application security. 

 

Supporting Activity: Database Recovery Process

Write a 200- to 300-word short-answer response for the following:

•  Suppose that the database system within your organization has failed. Describe the

     database recovery process.

 

 

***** BONUS FILES INCLUDED WITH PURCHASE *****

 

Learning Team: Big Data

TWO Presentations Included!

The amount of data that large organizations must manage is vast. The concepts of managing "big data" are much different than traditional application databases (those similar to the diamond broker application, for example).
Prepare a 10- to 12-slide Microsoft PowerPoint presentation with detailed speaker notes that answers the following:
      • How do organizations like Amazon, Facebook, or Google manage their "big data"

          systems?
      • Explain the challenges these organizations face with managing these large systems
      • Recommend tools and techniques these organizations could use to help in the

         management of these systems
      • List the key functions that must be included in these tools Include at least three

         external sources as a part of your research.
Submit your presentation to the Assignment Files tab.

 

Learning Team: SmallMart Presentation to CEO

Principles of Database Management

Create a 5- to 7-slide Microsoft PowerPoint Presentation in which you explain the principles of database management and make recommendations for continued management of the database you created in your learning team project.

The presentation to the CEO should include information on the database development life cycle which includes:

     • An ERD.

     • How you approached normalization.

     • Any decisions that were made around keys, data types, constraints, etc.

Include at least three external sources as a part of your research.
Submit your presentation using the appropriate Assignment Files tab.