![subject](/tpl/images/cats/informatica.png)
Computers and Technology, 10.12.2019 04:31 Maxwell8066
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
![ansver](/tpl/images/cats/User.png)
Answers: 3
Another question on Computers and Technology
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 17:30
Under which key category do the page up and page down keys fall? page up and page down keys fall under the keys category.
Answers: 1
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 20:00
What is the worst-case complexity of the maxrepeats function? assume that the longest string in the names array is at most 25 characters wide (i.e., string comparison can be treated as o( class namecounter { private: int* counts; int nc; string* names; int nn; public: namecounter (int ncounts, int nnames); int maxrepeats() const; }; int namecounter: : maxrepeats () { int maxcount = 0; for (int i = 0; i < nc; ++i) { int count = 1; for (int j = i+1; j < nc; ++j) { if (names[i] == names[j]) ++count; } maxcount = max(count, maxcount); } return maxcount; }
Answers: 3
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 01:30
In deadlock avoidance using banker’s algorithm, what would be the consequence(s) of: (i) a process declaring its maximum need as maximum possible for each resource. in other words, if a resource a has 5 instances, then each process declares its maximum need as 5. (ii) a process declaring its minimum needs as maximum needs. for example, a process may need 2-5 instances of resource a. but it declares its maximum need as 2.
Answers: 3
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 24.06.2019 12:30
Select all that apply. what two keys listed below should you use to enter data in an excel worksheet? tab backspace enter right arrow
Answers: 2
You know the right answer?
Here are the list of entities and attributes that i have started with. below these are the instructi...
Questions
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 21.08.2020 22:01
![question](/tpl/images/cats/himiya.png)
Chemistry, 21.08.2020 22:01
![question](/tpl/images/cats/ekonomika.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 21.08.2020 22:01
![question](/tpl/images/cats/mat.png)
Mathematics, 21.08.2020 22:01
![question](/tpl/images/cats/mat.png)
Mathematics, 21.08.2020 22:01
![question](/tpl/images/cats/mkx.png)
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 21.08.2020 22:01
![question](/tpl/images/cats/istoriya.png)
![question](/tpl/images/cats/obshestvoznanie.png)
Social Studies, 21.08.2020 22:01
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/ekonomika.png)
![question](/tpl/images/cats/es.png)
Spanish, 21.08.2020 22:01
![question](/tpl/images/cats/biologiya.png)
![question](/tpl/images/cats/istoriya.png)
![question](/tpl/images/cats/health.png)
![question](/tpl/images/cats/istoriya.png)
History, 21.08.2020 22:01