Discuss the database design

Assignment Help Database Management System
Reference no: EM13949925

Scenario - Discuss database design:

1. Colors for models:

a. Classic red, blue, green

b. Competition: silver, black

c. RoboZid: baby blue, pink, yellow.

2. Personalizaton limits:

a. Classic: 1 line, 12 letters

b. Competition 2 lines, 8 letters

c. RoboZid: 2 lines, 5 letters

3. Cannot ship to P.O. Box

4. Manufacturing Process:

a. Order, build, paint/ personalize, mail

b. Each step takes 7 days except mail, which is the next day after personalize.

5. They want ot add calculation of shipping and tax.

6. Model numbers will always be four digits.

Reference no: EM13949925

Questions Cloud

How you view different managerial styles : Write an essay (between three and five pages) about how you view different managerial styles. For instance, we have the military authority style, the participatory style of academics and community committee groups, and a mixture of work styles in ..
Interruption of electrical power : Homeowners concerned about interruption of electrical power from their local utility because of weather-related and utility system outages can acquire a standby generator that produces electricity using the home's existing natural gas or liquid pr..
Why and how would you suggest the selection be done : Why, and how would you suggest the selection be done, if not? What is Sarbanes Oxley ACT (SOX) position on peer review?
What is an exchange rate for currency : What is an exchange rate for currency? What is the difference between a spot rate and a future rate? What is transaction risk? Economic risk? Translation risk?
Discuss the database design : Each step takes 7 days except mail, which is the next day after personalize.
Evaluate the rate of heat transfer : For a control volume enclosing the heat exchanger, evaluate the rate of heat transfer, in kJ per kg of water flowing.
Negligible kinetic and potential energy effects : A counterflow heat exchanger operates at steady  state with negligible kinetic and potential energy effects. In one stream, liquid water enters at 108C and exits at 208C with a negligible change in pressure.
The partnership of x and y shares profits and losses : Assume X's beginning capital balance was $80,000, and ending capital balance (after closing) was $140,000.
Determine the heat transfer : For a control volume enclosing the nozzle only, determine the heat transfer, in kJ, and the change in specific  entropy, in kJ/K, each per kg of carbon monoxide flowing through the nozzle. What additional information would be required to evaluate ..

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