Yearly Archives: 2022

Database Recommendation   Includes: Option #1   Includes: Option #2   The first and most important database-related decisions are whether to use a database at all and, if so, which database management system to use and why. Today there are dozens of database management systems available; however, some are better suited to specific business environments […]

Database Administrator   Includes Option #1   Includes Option #2   Imagine that you have the educational background, skills, and abilities to be a database administrator. The XYZ company recently announced a vacancy for a database administrator position, and you are very interested because XYZ is known as a high-paying employer that is enjoyable to […]

Select and Update Data in Related Tables   Includes Option #1   Includes Option #2   Running reports on existing data and updating data records are very common tasks in the industry.   For this assignment, you will begin with a database containing several pre-populated tables.   Download and unzip the Microsoft® Access® database (ZIP […]

Create and Populate a Database   Instructions:   Resources: “SQL CREATE DATABASE Statement,” “SQL CREATE TABLE Statement,” “SQL PRIMARY KEY Constraint,” “SQL FOREIGN KEY Constraint,” and “SQL INSERT INTO Statement”   For this assignment, you will create the database you designed in Week 2.   Download the Create a Database document and follow the instructions. […]

Normalized Database Design Assignment   Includes Assignment and MS Visio ERD Diagram (fully editable!)   A relational database must be designed and normalized before it can be created, populated with data, and used. Database design depends on the business scenario(s) a database architect needs to model, but all relational database designs benefit from being normalized. […]

The first and most important database-related decisions are whether to use a database at all and, if so, which database management system to use and why. Today there are dozens of database management systems available; however, some are better suited to specific business environments and applications than others.   For this assignment, you will analyze […]

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: […]