Answer Happy

Oracles Technology (ORT) is an IT company offering vast assortment of IT hardware products and services to its customers. Although the company is performing well, there is nothing extraordinary about it: it is nothing more than a well-oiled organization, employing great people in present but flat hierarchies. As you will be working with ORT's DB, ORT's MIS department supplied you with some documents to begin your DB consulting work. To start, the model of ORT's database is presented below: CONTACTS CONTACT_ID FIRST_NAME LAST_NAME EMAIL PHONE CUSTOMER_ID CUSTOMERS OH CUSTOMER_ID NAME ADDRESS WEBSITE CREDIT_LIMIT ORDERS ORDER_ID CUSTOMER_ID STATUS SALESMAN_ID ORDER_DATE EMPLOYEES EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL PHONE HIRE DATE MANAGER_ID JOB_TITLE COUNTRIES COUNTRY_ID COUNTRY_NAME REGION ID Ha LOCATIONS LOCATION_ID O ADDRESS POSTAL_CODE CITY STATE COUNTRY_ID ORDER_ITEMS ORDER_ID ITEM_ID PRODUCT_ID QUANTITY UNIT PRICE REGIONS REGION_ID REGION NAME WAREHOUSES WAREHOUSE ID WAREHOUSE NAME LOCATION_ID INVENTORIES PRODUCT_ID OA WAREHOUSE_ID QUANTITY 生 PRODUCTS PRODUCT_ID PRODUCT NAME DESCRIPTION STANDARD COST LIST_PRICE OCATEGORY_ID PRODUCT_CATEGORIES CATEGORY_ID CATEGORY_NAME 主 Although you still do not have the complete access to ORT'S RDBMS, ORT's DBA Ali was kind enough to provide you an excerpt of the data you will be working with in a separate XLSX file attached. After all, you will only be providing some rudimentary services and proof of concepts, so you do not actually need a complete access to the complete database with operational business data in it. He also mentions that they just start experimenting with one new entity and that that particular entity might not be present in the database model. You spent some time inspecting those files and after you ended up establishing the first impression of ORT's data resources you decided to start answering Ali's questions presented below.

Q5a: This question focusses on normalization. Ali remembers that he had a difficult time grasping the finesses behind the normalization process and he asks you to show him one example of removing transitive dependencies using the data excerpt he provided to you (you are allowed to alter the table/s if necessary). He is also curious to know why business are often denormalizing the tables they previously normalized. Q5b: While going over the ORT's model you notice that Ali kept using the abbreviations ERD and EERD interchangeably as if those two abbreviations are synonyms. Explain why that is not the case and provide one design alteration that would render the given model into EERD. You do not have to draw the alteration, however you have to explain it in detail and tie it to the ORT's case.