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

  What must a user guarantee with respect to a transaction and

What must a user guarantee with respect to a transaction and database consis-tency? What should a DBMS guarantee with respect toconcurrent execution of several transactions and database consistency?

  Normalisation

Normalisation of relations which identifies: Dependency diagram for each relation, The level of Normalisation achieved for each relation;, The reasons for any relation that is maintained NOT in 3NF.

  How is the logical-to-physical address mapping accomplished

If we are currently at logical block 10 (the last block accessed was block 10 ) and want to access logical block 4, how many physical blocks must be read from the disk?

  Compute variable overhead spending variance

Order Up, Inc. provides order fulfillment services for e-commerce merchants. The company maintains warehouses that stock items carried by its clients.

  Draw a fully-labeled erd that includes entities

Draw a fully-labeled ERD that includes entities, labeled relationships (indicate whether each relationship is mandatory or optional), primary keys, foreign keys, and cardinalities. Follow the format (Crow's Foot notation) and naming conventions.

  When you add a calculated field to a query it creates a new

When you add a calculated field to a query it creates a new

  Logical database design - conceptual database design

Draw the corresponding GRD, exhibiting all the primary keys and foreign keys. For simplicity, no other attributes nor multiplicity constraints are required.

  Write an essay about effects of big data

Write an essay about effects of big data.

  How database systems support enterprise and web-based app

Summarize the difference between on-line transaction processing (OLTP) and online analytic processing (OLAP), and their relationship among business intelligence, data warehousing and data mining.

  Calculate the total cost for each event

Find all maincourses that have not been served at wedding receptions. List out the description - Calculate the total cost for each event - Find all maincourses that have not been served at wedding receptions. List out the description.

  Explain how queries are processed by the oracle dbms

Explain how queries are processed by the Oracle DBMS and Explain how transactions are processed by the Oracle DBMS

  Raci diagram for project resources

Write a 5-page plan (be sure to include a short description of the project used) that includes a list of project stakeholders, a RACI diagram for project resources, and a communication plan for one of the following project scenarios

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