![130005401](/avatars/7904.jpg)
130005401
10.12.2019 •
Computers and Technology
Here are the list of entities and attributes that i have started with. below these are the instructions to create a improved database and edit these and add some others.
customer_t
customerid (pk)
customername
customerstreet
customercity
customerstate
customerzip
creditlimit
salesrepid (fk) of employee_t
order_t
orderid (pk)
customerid (fk) of customer_t
customerponumber
orderdate
duedate
shipdate
order_line_t
orderid composite (pk), (fk) of order_t
productid composite (pk), (fk) of product_t
orderquantity
product_t
productid (pk)
productdescription
unitprice
stockquantity
fabricated_t
productid composite (pk), (fk) of product_t.productid
partid composite(pk), (fk) of product_t.productid
partquantity quantity of partid that goes into productid (example, 2 tires
in one bicycle)
product_supplier_t
producid composite (pk), (fk) of product_t
supplierid composite (pk), (fk) of supplier_t
vendorpartid this is the id the vendor (i.e., supplier) uses in their system), similar to
customerponumber in the order_t.
productcost
purchasedquantity
supplier_t
supplierid (pk)
suppliername
supplierstreet
suppliercity
supplierstate
supplierzip
employee_t
employeeid (pk)
employeename
employeestreet
employeecity
employeestate
employeezip
managerid (fk) unary
employee_course_t
employeeid combination (pk), (fk) of employee_t
courseid combination (pk), (fk) of course_t
completiondate
course_t
courseid (pk)
coursedescription
sales_commission_rate_t
employeeid (pk), (fk) of employee_t
commissionrate
using erwin, provide an erd diagram that adds the capability of tracking price changes to the database required for project 3. for example, products’ unit prices will change over time; therefore, for each productid, a given unit price will have a beginning date and an ending date. include both the printed erwin screenshot and the electronic version. think about the wording of the above paragraph carefully. since each the unitprice for each productid will change over time, and we need to store and maintain this information, unitprice then becomes a multi-valued attribute, and we know that this is unacceptable in 3rd normal form (3nf). since we must maintain 3nf, we must refer to the rules for handling a multi-valued attribute. in summary, you must create a new entity (i suggest the name price_history) that has a one-to-many relationship with product. unitprice must be removed from the product entity. price_history will have attributes of productid, startdate, enddate, and unitprice. since each productid will have multiple records in price_history, you must create a composite primary key for price_history based on two attributes (hint: unitprice is not one of
Solved
Show answers
More tips
- L Legal consultation How to Properly Inherit: Tips and Recommendations...
- H Health and Medicine Discover the Hidden Principles and Real Results of the Japanese Diet...
- H Health and Medicine Understanding Pregnancy Tests: What You Need to Know?...
- H Health and Medicine What Makes a Man a Man?...
- C Computers and Internet How to Get Rid of Spam in ICQ?...
- A Art and Culture Who Said The Less We Love a Woman, the More She Likes Us ?...
- F Family and Home How to Get Rid of Your Neighbors?...
- S Society and Politics How Could Nobody Know About the Dead Mountaineers?...
- H Health and Medicine How to Cure Adenoids?...
- H Health and Medicine Why Wearing a Back Brace Can Be Beneficial During Back Strain?...
Answers on questions: Computers and Technology
- C Computers and Technology In this exercise you will debug the code which has been provided in the starter file. The code is intended to take two strings, s1 and s2 followed by a whole number, n, as inputs...
- C Computers and Technology My internet works but my router won t let any devices connect to it unless you use a cat. 5 cable : \ what should i do?...
- C Computers and Technology PLEASE ANSWER ASAP Select the correct answer from each drop-down menu. Which IF formulas are valid? and are valid IF formulas,...
- M Mathematics Перечислите все целые числа, расположенные между числами –6,6 и –1,2....
- S Social Studies Why do scientists use models? (2 points) a. To collect and record data through the scientific methodb. To explain difficult concepts and show how things workc. To make conclusions...
- H History 1. What does MAIN stand for?...
- M Mathematics I need help with number 1 I don’t understand I’ll give BRAINLIEST to whoever helps me the best...
- S Social Studies Try creating your own thematic collage. Choose one of the symbols in Roll of Thunder, Hear My Cry, and create a collage that reflects how the symbol relates to one of the novel s...
- E English 3. Using a story map, explain the plot of the story in train to busana. exposition,b. conflict,c. climax, andd. resolution?...
- F French With a little help from her friends, Brigitte finds a new room. Create a question, using all elements of the original statement and qui or à qui, that corresponds to the item of information...
Ответ:
B
Explanation:
I think