Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Simple Database Design and do the simple relation scheme model for that class, and define the primary key and explain your choice. Also, identify any

Simple Database Designimage text in transcribed

and do the simple relation scheme model for that class, and define the primary key and explain your choice. Also, identify any candidate keys that you see besides the primary key (which is still a candidate key, remember) and explain why those other candidate keys were not the best choice for the primary key.

**** Also define all your classes in english

**** For the classes just a simple class with some attribute and " NO function"

*** For the primary key just identify them and state the reason you chose them.

*** For relation Schema just show them in simple diagram

****** Bellow is the example of what is requested ! *******

image text in transcribed

Design classes to represent three "things" from any enterprise that you find. a. For instance, if you were to draw classes from a warehouse, you might pick such things as "Stockltem", "Employee", and "ShelfLocation" as things that you wanted to model b. Similarly, were you to model things in an In and Out Burger, you might include such things as "Order", "Menu ltem" and "StoreLocation

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intelligent Databases Technologies And Applications

Authors: Zongmin Ma

1st Edition

1599041219, 978-1599041216

More Books

Students also viewed these Databases questions