Isom database assignment

Assignment Help Database Management System
Reference no: EM13780447

Description:

You are provided with a case which will be used for the assignments dealing with design and implementation of database. The purpose it to help translate material covered in class to a case that introduces you to some of the complexities of real world scenario.
For this assignment -- you are instructed to use only two specific items from the case (both of which are included in this document):
part 1
1. the lists you are required to create are clearly marked in a red box. Using MS-Excel, create the separate lists for Figure PAS-1. The information that needs to be stored in each list,  All the lists should be on a single worksheet. Name the worksheet Design Bid

a. Each list should contain appropriate column names.

b. Enter the data provided for the two different Design Bids samples into each list (provided below).

2.All the lists should be on a single worksheet. Name the worksheet Production Plan

a. List should contain appropriate column names.

b. Enter the data provided for the Production Plan below.

Part 2

3. For Design Bid
On a worksheet named Design Bid Themes

a. For each list from Part 1

i. For each list: show the list from Part 1 with only the column names

ii. For each list: identify all the different themes.

 Name each theme appropriately

 Include the columns included in that theme.

Note: a column must not repeat in two different themes.

 Include only two rows of data from Part 1 under each theme. Only when two rows of data is not available, include only one row.

4. For Production Plan List On a worksheet named Production Plan Themes

a. For each list from Part 1

i. For each list: show the list from Part 1 with only the column names

ii. For each list: identify all the different themes.

 Name each theme appropriately

 Include the columns included in that theme.

Note: a column must not repeat in two different themes.

 Include only two rows of data from Part 1 under each theme. Only when two rows of data is not available, include only one row.

Part 3

5. Convert all the themes from Design Bid List into Tables

a. Introduce additional columns as necessary

b. Include the rows of data in each table

c. Show reference arrows for columns

6. Convert all the themes from Production Plan List into Tables

a. Introduce additional columns as necessary

b. Include the rows of data in each table

c. Show reference arrows for columns

Reference no: EM13780447

Questions Cloud

What is the christian concept of the imago dei : What is the Christian concept of the imago dei - How might it be relevant to our unique approach in health care and why is it important?
Develop the mixed model repeating sequence : A schedule calls for producing 40 As, 20 Bs, and 30Cs. Process time is 5 minutes per A, 8 minutes per B, and 10 minutes per C. Develop the mixed model repeating sequence. Assuming 60 seconds changeover between products, how long will the scheduled pr..
Is anything still unclear that could be clarified : How did participating in discussions help your understanding of the subject matter? Is anything still unclear that could be clarified? What approaches could have yielded additional valuable information
Higher quality cost more money : Define quality and think of an operation where and why higher quality cost more money. Give some detailed examples.
Isom database assignment : You are provided with a case which will be used for the assignments dealing with design and implementation of database.
Differs between organizations and consumers : Apply the buying center concept to a firm, a non profit organization, or a government agency you work for, or are familiar with, for the purchase of new laptop computers for their employees. Which members of the buying center should the salesperson f..
Position brookhart argues : Explain the position Brookhart argues in Chapter 2 against rubrics that merely summarize the requirements of the task, as opposed to rubrics that describe evidence of learning.
What was the volume of digital evidence : Select a real world event related to Cybersecurity. This could be a crime, a well-documented breach or intrusion, or an act of cyber warfare/espionage.Needs to be 10 pages.APA format along with no plagiarism. Will be run through plagiarism site ..
Describe ethical code of conduct for employees and vendors : The legal regulations of conducting business overseas, The ethical code of conduct for employees and vendors, Guidelines for adherence to EEOC, ADA, and Civil Rights laws, Distinguishing between right and wrong in business dealings and when an action..

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd