Week 7 On Your Own Homework 13-1 Worth 75 points Note: Microsoft Office Suite 2013 (PC), 2011 (Mac), or more recent software is required to complete each homework assignment. Note: Some On Your Own projects have been modified for students using Microsoft Office 2011 for Mac software. Students should select the appropriate version of the […]
Problem #1 (20 points) Display the CustomerID, the customer’s name, the shipping city and state. Show the customer’s name in one column as the LastName concatenated to the FirstName separated by a comma and a space – for example: Brauda, Pamela. Show the city and state in one column separated by a comma and space […]
Set Class Write an implementation of the set class, with associated iterators using a binary search tree. Add to each node a link to the next smallest and next largest node. Note: To make your code simpler, add a header and tail node which are not part of the binary search tree but help make the linked […]
Domain Model Using Visio, construct a domain model of the system required for the course project described in Week 2. W2 Assignment for refference (attached W2 files for refference) W2 Assignment Use Cases Create high-level use cases for the customer requirements described in the W2 Course Project Instructions.” Example: A high-level use case for an […]
Start working on your Learning Team Database and Presentation outlined above with delivery in Week Four. Begin by analyzing the requirements provided. Identify the tables, fields, field attributes, and table relationships required. 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 […]
In your Leaning Team this week, you built an Entity-Relationship Diagram (ERD) for Sparkle Diamonds, Inc. For this assignment, practice your skills with creating ERDs by adding in the specification of the yellow-colored diamonds in the color scale K, L, and M, which are all classified as “faint yellow.” Use Microsoft® Visio®, Lucidchart, or another software tool of your […]
Imagine that you work for a finance industry-based organization. Your organization is looking to submit its database design documentation to an evaluation team in order to meet Sarbanes-Oxley (SOX) compliance. You have been assigned to assist in preparing the documentation of the organization’s sales database. You are asked to propose a data dictionary that can […]
Design and implement an interpreter that executes the code written in PEY(made up) language. The statements in PEY language are in the attachments.LAO=PEY
database administrator for a local department store Imagine that you have been hired as the database administrator for a local department store. The department store has recently expanded by opening five (5) stores within your local region. They have also launched a series of marketing campaigns to attract new customers and increase sales. For your […]
Imagine that you have been hired as a consultant to assist in streamlining the data processing of an international based organization that sells high-end electronics. The organization has various departments such as payroll, human resources, finance, marketing, sales, and operations. The sales department is the only department where employees are paid a commission in addition […]
