IS3063 – HW2 HW2 (120 points) Prepare a script that creates a physical database that implements the schema reported in the next page. The schema name must be is3063_hw2. The database must...

My SQL


IS3063 – HW2 HW2 (120 points) Prepare a script that creates a physical database that implements the schema reported in the next page. The schema name must be is3063_hw2. The database must include every entity and attribute included in the EER diagram. Remember to use the exact names for both entities and attributes and to keep the order of attributes as they are listed in the diagram. Also, you must implement all the primary keys and foreign keys represented in the EER diagram. Grading Rubric: 1. The Physical Database in MySQL (total 120 points) format must: � Implement the EER Diagram as it is (30 points) � Use the correct names and order for entities and attributes (15 points) � Each table must have defined a primary key (30 points) � All the foreign keys must be defined (30 points) � Must run the verification script (HW2verify.sql) without errors (15 points) Some info about primary keys: • All primary key types are VARCHAR • For the PK size, follow these rules: o INSTITUTION: VARCHAR(4) o STU_TYPE: VARCHAR(3) o JOURNAL: VARCHAR(10) o AUTHOR: VARCHAR(4) o STU_STATUS: VARCHAR(4) o ARTICLE: VARCHAR(10) o STUDY: VARCHAR(10) Check the script HW2verify.sql to identify the types of the remaining attributes. Deliverable: a SQL script file working without errors with MySQL (upload to Blackboard) Deadline: See Blackboard IS3063 – HW2 A` AUTHOR AFFILIATIONORGANIZATION STUDY COLLABORATION STUDYTYPE ARTICLE JOURNAL AUTHORSHIP STATUS AUTHOR_CODEPK FNAME LNAME MNAME ORGANIZATION_CODEFKPK DEPARTMENT IS_MAIN_AFFILIATION ORGANIZATION_CODEPK DESCRIPTION AUTHOR_CODEFKPK STUDY_CODEPK TITLE TYPE_CODEFK STUDY_CODEFKPK NOTE AUTHOR_CODEFKPK TYPE_CODEPK DESCRIPTION ARTICLE_CODEPK TITLE KEYWORDS JOURNAL_CODEPK DESCRIPTION ABS_RANK ARTICLE_CODEPK CORRESPONDING AUTHOR_CODEPK ORDERPK EMAIL JOURNAL_CODEFK DATE STATUS_CODEFK STATUS_CODEPK DESCRIPTION STU_TYPE STU_STATUS INSTITUTION