Hello, Working with databases is very new to me, I would really appreciate your

Question

Hello,

Working with databases is very new to me, I would really appreciate your help if possible! Again, thank you so very much!


Question:

Develop the database that will satisfy the specifications that you developed in your analysis of the problem assigned to your group in week 3. Populate the database tables with the data from the table in the problem statement. You may need to create data for fields that needed to be created to solve the problems that you identified in the table or are required for the proper operation of the database.

Do not forget to create SQL statements that demonstrate that your database design works correctly.
----------------------------------------------------------

Week 3 Problem:

A). Given the structure shown below, write the relational schema.

The relational schemas used in the figure above are:

-EMPLOYEE (EMP_CODE, EMP_LNAME, DEPT_CODE, JOB_CLASS, EMP_DOB,

EMP_HIREDATE)



-DEPENDENT (EMP_CODE, DEP_NUM, DEP_FNAME, DEP_TYPE)



-DEPARTMENT (DEPT_CODE, DEPT_NAME, EMP_CODE)



-JOB (JOB_CLASS, JOB_TITLE, JOB_BASE_SALARY)



-EDUCATION (EDUC_CODE, EDUC_DESCRIPTION)



-QUALIFICATION (EMP_CODE, EDUC_CODE, QUAL_DATE_EARNED)


C). Draw the relational diagram.

Explanation / Answer

command to create sql : a) database : create database database-name b) table : create table tablename ( attribute1 int, attribute 2 varchar(20), primary key(attribute1) ); c) to insert elements in table : insert into table-name values ( v1,v2,v3); To check your desing you can write the following query: select employee.dept_code from employee inner join dependent on employee.emp_code = dependent.emp_code Any more clarifications needed, just comment or leave a message @my inbox

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.