Question: use oracle sql best regards Empley Event PK MLMO w PK Mentar alone no Event PKM G Lotton Ferre PK Lara Map your logical model





Empley Event PK MLMO w PK Mentar alone no Event PKM G Lotton Ferre PK Lara Map your logical model (ERD) from question 2 into a set of tables. Use the Create Table SQL to create all tables, and create a Data Dictionary for each table. The Data Dictionary should include: Table Name Column Name (Choose appropriate column to describe each Entity) Primary keys, foreign keys, alternate keys Data types and size Allowable values Description of attribute and entities Derived data Assumptionsotes . . Use the following template for your answer: Table Name: XXX Column Primary Foreign Alternate Data Name Key Key Key type & size Allowable Description Derived Notes/ value Data assumptions Note: All the entities should be mapped to tables and should include bridge entities for N:M relationships, Ensure that the tables are in 3rd Normal Form (no need to show normalization), Employees PK em no Instrame last name emal omobile address Employee_schedule _no Dutes no PK duties no 2 duties type galeriano start date end date Galerta PK gallerie_no Man name PK hal_no OFK1 Galeria non Capacity itom Valting Artist PK temno Artiet Displaying PK a no TK PK van dersion esempi Local Artist Employees PK me ployee Event event_no Employee schedure PK _ _ PK telo ty TO and Gaberta PK ad cal inst PE Along ng Arthur PK Run PK 11 Employoo_Evant PK emp_event.no FK Sno Employee FK2 evento PK no Valtor start date FK1 empo end date PK Visitor_no FK 2 duties no ve FO gloriano mobile start date Event PK vanno end date ename description Event Sales FK galleriano PK 1.no PK gale bro Gallery Location PK location no TKI ever ne hal na bor tar door Locat Donation PKWC PK tamno arden Karl Local Art tre I FK ALL PN Dube ha FO Guten - PK Ganwy, La FK CON Attring PK te PK V Local Artist PK Employee DU NON ha PK re get PRO PK Gallery Location PR location PK Local Art Dention PK ad_he PK Empley Event PK MLMO w PK Mentar alone no Event PKM G Lotton Ferre PK Lara Map your logical model (ERD) from question 2 into a set of tables. Use the Create Table SQL to create all tables, and create a Data Dictionary for each table. The Data Dictionary should include: Table Name Column Name (Choose appropriate column to describe each Entity) Primary keys, foreign keys, alternate keys Data types and size Allowable values Description of attribute and entities Derived data Assumptionsotes . . Use the following template for your answer: Table Name: XXX Column Primary Foreign Alternate Data Name Key Key Key type & size Allowable Description Derived Notes/ value Data assumptions Note: All the entities should be mapped to tables and should include bridge entities for N:M relationships, Ensure that the tables are in 3rd Normal Form (no need to show normalization), Employees PK em no Instrame last name emal omobile address Employee_schedule _no Dutes no PK duties no 2 duties type galeriano start date end date Galerta PK gallerie_no Man name PK hal_no OFK1 Galeria non Capacity itom Valting Artist PK temno Artiet Displaying PK a no TK PK van dersion esempi Local Artist Employees PK me ployee Event event_no Employee schedure PK _ _ PK telo ty TO and Gaberta PK ad cal inst PE Along ng Arthur PK Run PK 11 Employoo_Evant PK emp_event.no FK Sno Employee FK2 evento PK no Valtor start date FK1 empo end date PK Visitor_no FK 2 duties no ve FO gloriano mobile start date Event PK vanno end date ename description Event Sales FK galleriano PK 1.no PK gale bro Gallery Location PK location no TKI ever ne hal na bor tar door Locat Donation PKWC PK tamno arden Karl Local Art tre I FK ALL PN Dube ha FO Guten - PK Ganwy, La FK CON Attring PK te PK V Local Artist PK Employee DU NON ha PK re get PRO PK Gallery Location PR location PK Local Art Dention PK ad_he PK
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
