The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Jul 2017 |
| Last Sign in: | 304 Weeks Ago, 5 Days Ago |
| Questions Answered: | 15833 |
| Tutorials Posted: | 15827 |
MBA,PHD, Juris Doctor
Strayer,Devery,Harvard University
Mar-1995 - Mar-2002
Manager Planning
WalMart
Mar-2001 - Feb-2009
With the data dictionary diagram of the database in attached file, explain the tables and the relationships between the tables. Be specific and thorough about the relationships..DB_APEX_016.ATTENDANCES P * ATTND_ID VARCHAR2 (3 BYTE) F * ATTND_WKSHP_ID VARCHAR2 (3 BYTE) F * ATTND_STDID VARCHAR2 (10 BYTE) PK_ATTEND (ATTND_ID) FK_STUDENTS (ATTND_STDID) FK_WORKSHOPS (ATTND_WKSHP_ID) PK_ATTEND (ATTND_ID) DB_APEX_016.WORKSHOPS P * WKSHP_ID VARCHAR2 (3 BYTE) * WKSHP_NAME VARCHAR2 (30 BYTE) PK_WORKSHOPS (WKSHP_ID) PK_WORKSHOPS (WKSHP_ID) DB_APEX_016.STDMAJOR_LOOKUP P * STDMAJOR_ID NUMBER U * STDMAJOR VARCHAR2 (4000 BYTE) STDMAJOR_LOOKUP_PK (STDMAJOR_ID) UNIQ_STDMAJOR (STDMAJOR) UNIQ_STDMAJOR (STDMAJOR) DB_APEX_016.TEAMS P * TEAMID VARCHAR2 (8 BYTE) U * TEAM_NAME VARCHAR2 (30 BYTE) F PROJECTID NUMBER PK_TEAMID (TEAMID) UNIQ_TEAM (TEAM_NAME) FK_PROJID (PROJECTID) PK_TEAMID (TEAMID) UNIQ_TEAM (TEAM_NAME) DB_APEX_016.STUDENTS P * STDID VARCHAR2 (4 BYTE) U * STDUSERID VARCHAR2 (8 BYTE) * STDFNAME VARCHAR2 (12 BYTE) * STDLNAME VARCHAR2 (13 BYTE) F STD_TEAMID VARCHAR2 (8 BYTE) F STDMAJOR_ID NUMBER PK_STDID (STDID) UNIQ_STDUSERID (STDUSERID) FK_TEAMID (STD_TEAMID) SYS_C0018534 (STDMAJOR_ID) PK_STDID (STDID) UNIQ_STDUSERID (STDUSERID) DB_APEX_016.PROJECTS P * PROJECTID NUMBER * PROJ_NAME VARCHAR2 (45 BYTE) PROJ_CLIENT VARCHAR2 (35 BYTE) PK_PROJECTID (PROJECTID) PK_PROJECTID (PROJECTID) DB_APEX_016.EVALUATIONS P * EVAL_ID NUMBER F * EVALUATORID VARCHAR2 (4 BYTE) F * EVALUATEEID VARCHAR2 (4 BYTE) EVALSEMESTER VARCHAR2 (10 BYTE) EVALYEAR NUMBER (*,0) PK_EVAL (EVAL_ID) FK_EVALUATEEID (EVALUATEEID) FK_EVALUATORID (EVALUATORID) PK_EVAL (EVAL_ID) DB_APEX_016.EVAL_ITEMS P * EVAL_ITEM_ID VARCHAR2 (3 BYTE) U * EVAL_ITEM_CODE VARCHAR2 (13 BYTE) * EVAL_DESCRIP VARCHAR2 (35 BYTE) PK_EVAL_ITEMS_ID (EVAL_ITEM_ID) UNQ_EVAL_ITEM_CODE (EVAL_ITEM_CODE) PK_EVAL_ITEMS_ID (EVAL_ITEM_ID) UNQ_EVAL_ITEM_CODE (EVAL_ITEM_CODE) DB_APEX_016.EVAL_ITEM_SCORES P * EVAL_SCORE_ID NUMBER F * EVAL_ID NUMBER F * EVAL_ITEM_ID VARCHAR2 (3 BYTE) * SCORE NUMBER PK_EVAL_ITEM_SCORE (EVAL_SCORE_ID) FK_EVAL_ID (EVAL_ID) FK_EVAL_ITEM_ID (EVAL_ITEM_ID) PK_EVAL_ITEM_SCORE (EVAL_SCORE_ID)
Attachments:
----------- Â ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly