Product(pname, price, category, maker), Purchase(buyer, seller, store, product), Company(cname, country), Person(name, address, phone); maker →…
Product(pname, price, category, maker), Purchase(buyer, seller, store, product), Company(cname, country), Person(name, address, phone); maker → Company.cname, buyer/seller → Person.name, product → Product.pname. Draw the ER diagram, then write the queries.
(a) People who bought products made by American companies.
(b) Total value of products per country of origin (listed, and actually sold).
From the NWPGCL Assistant Manager (ICT) January 2024 – Written (BUET) exam, question 2 of 5.
More from this paper
- Previous: Tax program. Slabs: first 2,50,000 tax-free; next up to 5,00,000 at 10%; next up to 10,00,000 at 20%; above 10,00,000 at 30%. (a) Write a…
- Next: An IP address 192.168.1.50 with subnet mask 255.255.255.240. Find the network address, broadcast address and valid host range.
- All questions in NWPGCL Assistant Manager (ICT) January 2024 – Written (BUET)