Question: Problem 3: (8 points) Consider the following 3NF relations about a BALADNA BIG STORE; CUSTOMER (Cust ID, Name, Address) ORDER (Order ID, Date) INVENTORY (Inv

Problem 3: (8 points) Consider the following 3NF relations about a BALADNA BIG STORE; CUSTOMER (Cust ID, Name, Address) ORDER (Order ID, Date) INVENTORY (Inv ID, Item,name, Weight) SHOPPING_CART (Cart ID, Cust_ID, Order ID, INV ID, Qty) a. Determine and indicate the Foreign keys these relations? justify your Answer. 13 points) b. Draw an E-R diagram for these relations. ( 3 points) c. Explain the assumptions you made about cardinalities in your answer to part b? (2 points) c. Build a normalized relations (Tables) i.e 3NF? (6 points)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

plssss solve i dont have much time Problem 3: (8 points) Consider the following 3 NF relations about a BALADNA BIG STORE: CUSTOMER (Cust ID, Name, Address) ORDER (Order ID, Date) INVENTORY (Inv ID,...

Problem 4: (5 points) 5. Consider the following relations : CUSTOMER (Cust ID, Name, Address) ORDER (Order ID, Date) INVENTORY (Iny ID, Item_name, Weight) SHOPPING_CART Cart ID, Cust_ID, Order_ID,...

This project goal is to develop a rental media system This underneath UML diagram may help you to understand the system requirements MediaRentalManger Media Rentalint Media Comparable> Customer Game...

The UML Entity Relationship at the bottom of this question is it correct based of the parts hightlighted? A Data Integration Model Some consultants believe it is inefficient to maintain multiple...

Some consultants believe it is inefficient to maintain multiple databases for the two companies whose merger was presented in the Discussion. They recommend a single data source as the best solution...

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

ISFM-300 Case Study, Stage 2: Business Process Analysis and Functional Requirements Before you begin this assignment, be sure you: 1. Have completed all previously assigned readings, particularly...

Hi, I have areport due in nine hours. I need to find the following list of things on Amazon.com....

Could I get the cost of capital calculation (WACC) broken out in excel for Amazon based on FY2015 financials? \fTo our shareowners: This year, Amazon became the fastest company ever to reach $100...

Goals: 1. Perform use-case analysis techniques to discover and specify the conceptual classes. 2. Use design principles to translate conceptual class design into an appropriate set of abstract and...

What makes a repair extraordinary (as opposed to ordinary)? Give an example of anextraordinary and an ordinary repair. What is the financial statement effect of recording a repair as an extraordinary...

A company requires reliable internet and phone connectivity between their 5 central offices across the region. They decided to lease dedicated fiber optic lines from the telco (telephone company)....

Which of the following items are classified as cash outflows from operating activities on the statement of cash flows? paryment of employee salaries interest pald on notes retirement of common stock...

Projects A and B are mutually exclusive and both have an initial cost of $88,000. Project A has annual cash flows for three years of $18,300, $34,500, and $52,300, respectively. Project B has annual...

5 There is also a need to think from different perspectives and at the different multifunctional, corporate and subsidiary levels. This requires managers to be open-minded, flexible and adaptable.

Whilst delayering and downsizing may be aspects of organizing which are contingent on responding to the needs of economic downturn, shareholders interests and efficiency, they may be less effective...

3 What specific practices, such as autonomous and cross-functional teams, and principles, such as empowerment, are best suited to which cultural contexts? How are these practices (with their...