Why Relational Databases Make Sense for Big Data   Read “Big Data and RDBMS: Can They Coexist?” from Information Week. Note: This article introduces the concept of big data and discusses the types of database models that can be used to implement extremely large amounts of data. It also points out some important benefits of […]

Database Administrator and Architect   Describe the differences between a database administrator and a database architect. How is your organization structured to handle the functions of these roles?   Database Service   Locate a hosted, distributed database service. Explore its features and talk about your experiences. In what situations would an organization consider using it? […]

Normalization Process   In your own words, describe the nature and purpose of the normalization process. Provide some examples from sources other than the readings   Disadvantage of Normalizing   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 […]

Data Warehouse Project, Part III   Use Microsoft Visio and an Excel spreadsheet or Word document to complete this assignment.   Identify and define all dimension attributes for the dimensions identified in the Week Two Individual Assignment, “Data Warehouse Project, Part II”.   For each dimension, document the following information for each of its attributes: […]

Specialist Database Presentation   Determine how spatial components can be used in the database your team created in Week Two.   Create an Entity Relationship Diagram (ERD) with spatial components. Use Microsoft Visio to create this diagram.   Include a minimum of two spatial components from the list below:   Longitude/Latitude   Polygon   Points […]

Data Warehouse Project, Part II   Includes 5 Long Answers to Discussion Question   Use the credit card database from the Week One Individual assignment, “Data Warehouse Project, Part I,” as a basis for the creation of a data warehouse.   Complete the following steps:   Define the business requirements, objectives, and deliverables.   Declare […]

Specialist Database Presentation   Your team is tasked with creating an inventory price-tracking database for a company of your choosing.   Complete the following steps in Microsoft® SQL Server® 2016:   Create a table. This table will tell you what price the inventory item started at, what it currently is, and what it ends at. […]

Complete the following using Microsoft SQL Server 2016:   Write SQL scripts in Microsoft SQL Server for OLTP that include:   A Data Definition Language (DDL) script creating the four tables with appropriate data types, primary and foreign keys   Data Manipulation Language (DML) scripts that insert a minimum of five records into each table […]

General vs. Special-Purpose Databases   Includes 5 Long Answers to Discussion Question   Identify a general purpose and a special purpose database of your choice. Research and compare the general and special purpose databases that you have selected. Describe differences between the two databases.       DBM384 Special Purpose Databases   Week 2 Discussion […]

Strengths and Weaknesses of Info Retrieval   Includes 5 Long Answers to Discussion Question   Select a website from the Internet that provides information to its stakeholders; examples of websites to consider are SEC.gov or USA.gov. Describe the strengths and weaknesses of the information retrieval processes used on this website from an end-user perspective.