how can we maintain data using dbms using coffee shop
how can we maintain data using dbms using coffee shop
We can maintain data of coffee shop by made of relational table of their attributes and store the information in specific attributes.
For example - we can store attributes like coffee_mfgID, price, quantity, flavoure, mfgDate, expDate, durationUse, shop_address.
coffee_mfgID - This attribute represents manufacturing ID of coffee which is unique, so that this makes a primary key of table and their type is int and not null.
price - This attribute is price of coffee, their type is numeric or int.
quantity - This shows the amount of coffee and type is int.
flavoure - This attribute for giving variety of coffee, type is varchar.
mfgDate - This attribute tells about manufacturing date information of coffee and their type is Date format.
expDate - This attribute tells about expiring date information of coffee and their type is Date format.
durationUse -This attribute gives information for best using period in which you can use the coffee and gets calculated from subtraction of mfgDate from expDate, hence it is a derived attribute.
shop_address - This attribute gives information about coffee shop and their type is varchar.
Step by step
Solved in 2 steps
