Solution-Creating an er model including entity classes

Creating an er model including entity classes

Assignment Help Database Management System

Reference no: EM13858005

Scenario

ABC Manufacturing would like you to create an inventory management system. The company has recieved significant value for your work on the database and ER diagram.

Tasks

You will need to start by creating an ER model, including both Entity Classes and attributes. This is to be done in MySQL Workbench.

Then, using both MySQL Workbench and MySQL Server, create a schema called ABC_YourLastName. In this schema, create all the necessary tables, columns, and relationships to meet the following requirements:

Track raw materials with various options including color and size.

Set minimum inventory levels that will trigger the ordering of replacement material.

Raw materials should be able to be assigned to multiple finished goods.

Material orders will need to be tracked for when orders are placed, received, and used so that trending data can be used.

At times a raw material will be replaced with a new product. The new product will need to be tracked to the product it replaced.

Reference no: EM13858005

Questions Cloud

How job stress contribute to deviant behavior in workplace : How can Job Stress contribute to unethical or deviant behavior in the workplace?(120 words)

Amount of miali supplies expense for the year : The cost of supplies purchased by the Miali company was $4500 during the year. Miali Used $3500 worth of those supplies during the year and still had $1000 worth of them left at year end. What was the amount of Miali's supplies expense for the y..

What are the most important elements of new product : A cross functional team at electronic toys has been assembled to create a range of new produces. what are the most important elements of new product development that that they need to focus their limited time on? justify to the group why

What information contained in the seven employees comments : What information contained in the seven employees' comments about their jobs relates to the core job characteristics of skill variety? answer should be at least 150 words.

Creating an er model including entity classes : You will need to start by creating an ER model, including both Entity Classes and attributes. This is to be done in MySQL Workbench

What income did allerton record from jenson : What income did Allerton record from Jenson in 2014? What income did Allerton record from Jenson in 2015? Record the journal entry to recognize the conversion to the equity method?

Develop a strategy for converting husky airs current system : Develop a strategy for converting Husky Air's current system to the new application system your consulting firm has developed. Be sure to explain why you have chosen one of the following conversion strategies.

What assumptions are made in such computations? : What assumptions are made in such computations?

Adjusting entry for manufacturing overhead : Prepare the adjusting entry for manufacturing overhead, assuming the balance is allocated entirely to Cost of Goods Sold.

User Account

All Pages

Creating an er model including entity classes

Reference no: EM13858005

Reference no: EM13858005

Questions Cloud

Reviews

Write a Review

Database Management System Questions & Answers

Knowledge and data warehousing

Design a database schema

Entity-relationship diagram

Implement a database of courses and students for a school

Prepare the e-r diagram for the movie database

Design relation schemas for the entire database

Prepare the relational schema for database

Data modeling and normalization

Use cases perform a requirements analysis for the case study

Knowledge and data warehousing

Stack and queue data structure

Practice on topic of normalization

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT