Mysql Create Tables Run Basic Queries Use Information Rs Diagram Tables Use Rs Created Lab Q37132590

MySQL Create tables and run basic queries

Use the information in the RS diagram for the tables

Employee Department PK eno dno PK ename dname eaddress dmngo bdate dno FK Works on Project FK eno PK pno phours FK pno ploc

  1. Use the RS created in Lab 3.2 and create the 4 tables in MySQLusing SQL commands.
  2. Populate the tables with enough test data to create 3 userqueries.
  3. Create 3 user queries of your choosing. For instance, you maywant to know what employees work for a particular department or howmany employees are working on the different projects.
  4. Take screenshots of the 4
    OR
    OR

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.