Question: Requirements Develop an ERD for PVAMU, which includes the following tables: student table, instructor table, and course table. Please specify a few attributes and identify

Requirements

Develop an ERD for PVAMU, which includes the following tables: student table, instructor table, and course table. Please specify a few attributes and identify PK and FK for each of the three tables.

(3

points

)

Besides these three tables, what are other tables that might be useful? Please identify another two tables that are related to your existing tables. Please specify a few attributes and identify PK and FK for these two new tables.

(2

points

)

Note that you do NOT have to use the correct ER cardinalities.

Submission:

Submit your work with Word, PDF

,

or pictures. You may handwrite your answer and take a picture of your work.

Requirements Develop an ERD for PVAMU, which includes the following tables:

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Scenario and Summary The lab for this week addresses taking a logical database design (data model) and transforming it into a physical model (tables, constraints, and relationships). As part of the...

Narrative/Case Study For this lab, you will be creating SQL statements to build a series of relational tables, using SQL CREATE statements in a script file format for the Student Database. You will...

DATABASE LAB PAGE 1 100 Points Total Developed by K. David Smith, Instructor, Computing and Technology Department Cameron University, Lawton, OK 1 Develop a relational Database in MS Access. The...

Do it on Microsoft Word amd Excel please! BUAD 283 MIS - Assignment 01 Entity-Relationship (E-R) Database Design Glenmore Glass, Inc. Project Database You have been asked by Jacinda Hill, the owner...

Do it on Word and Excel please:) BUAD 283 MIS - Assignment 01 Entity-Relationship (E-R) Database Design Glenmore Glass, Inc. Project Database You have been asked by Jacinda Hill, the owner operator...

database Design Project Contents Database Design Project Overview---------------------------------------------------------------------------- 2 Week 3 Company Overview and...

Hello. I'm a little lost with this. Supposed to be creating a database for a gourmet store. This is what I have in my data dictionary so far: this is an example of the data dictionary: blank sheets...

COMM 226 Business Technology Management Department of Supply Chain and Business Technology Management Assignment 2 - Part A Winter 2016 - Section Y You will complete this assignment in teams of 2...

Comment: Before you resubmit, also review your UML class diagram for a couple missing associations. Review also that every association has a foreign key identified (revisit your multiplicity...

these are clearer pics of Q3 and Q4 QUESTION 1 You are helping a homestay rental company to develop a new database. Below is the collected information about the company: - They are the middleman...

Nancy operates a business that uses the accrual method of accounting. In December, Nancy asked her brother, Hank, to provide her business with consulting advice. Hank billed Nancy for $7,800 of...

Merry Co. has two major categories of factory overhead: material handling and quality control. The costs expected for these categories for the coming year are: Material handling ... $120,000 Quality...

An employer who is subject to FUTA must file Form 9 4 0 V with the federal government. Normally, the form must be filed by February 2 if all deposits are made on a timely basis, the form may be filed...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

2. How can competencies be used in employee development?

3. Collaborative Learning: The learner can connect via the company intranet with tutors, team members, customers, or other learners to discuss problems, issues, and approaches and to share what has...

1. What role does assessment have in employee development? Can assessment alone be effective for development? Why or why not?