Recognizing design weaknesses

 

Design a set of 3NF tables (each is a separate problem) that capture all key data (PK and FK) necessary to track this data. Along the way, you may have to make assumptions due to the lack of familiarity with the domain – you would normally ASK the subject matter experts for clarification. List ALL assumptions you had to make to complete this.
In all situations, identify the tables needed clearly, all primary keys and a few non-key attributes to show the relationships as shown here:
TABLE1 (table1_PK, fields1, field 2…)
TABLE2 (table2_PK, field1, field2… table1_FK)

For bridge tables, be sure to identify the FKs properly

Sample Solution

erm orientation: These organisations generally looks towards achieving long term objectives they are generally future oriented. Indonesian culture is long term oriented, it believes on maintaining relationship and assume that employee will remain within the company for long period, while in western countries short term orientation culture is adopted. They feel that time is precious.

• Indulgence: It means how people control their own desires and children are socialised towards society. Indonesian have low indulgence as compared to Australia and New Zealand that means Indonesian people do not prefer leisure time and have control on their desires.

Section 2

Indonesia Archipalego: Indonesian archipelago is unique in terms of Asia because it has many islands and having more than 245 million population and majority of the population here is Muslim. Its culture is ethnically diverse and increasingly have urbanised population (Naafs 2013).

• Economic Structure: Indonesia Economy 2011 defines that every country has different economic systems. Initially Indonesia adopted liberal economic system in which communities perform economic activities. Thereafter socialist economic system came into existence, but in the new era socialist economic system again transformed into democracy economic system. This system continued until reformation and after reformation economic system based on social economy was adopted by government and still prevails in the Indonesia. Indonesian economy has seen very up and downs in the last few decades and it mostly depends upon the agriculture, manufacturing and service sectors. Agriculture is the primary sector, manufacturing comes on the secondary level and service sector is on the tertiary level (Indonesia economic structure 2010)

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, Welcome to Compliant Papers.