Hello, This database technology is new to me, and on top of that I am stuck, I a

Question

Hello,

This database technology is new to me, and on top of that I am stuck, I am embarrassed :( I would really appreciate your assistance if possible! if possible, can you show me in the SQL statement format, this would really be helpful due to being able to see how you arranged it. 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 Access Views or SQL statements that demonstrate that your database design works correctly.
----------------------------------------------------------

Week 3 Problem:

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

C). Draw the relational diagram.

D).Draw the Crow’s Foot ERD.

Explanation / Answer

If you want to create views use the following format: CREATE VIEW viewname AS for instance : CREATE VIEW view1 as SELECT dept_code FROM department INNER JOIN dependent ON department.emp_code = dependent.emp_code GROUP BY dep_type If you need more help in writing specific SQL queries, feel free to ask.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

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