using your knowledge of selecting entities and attributes complete the following tas 5189451

Using your knowledge of selecting entities and attributes, complete the following tasks for this week:

Review your project descriptions and come up with five entities and some attributes that describe the entities. Do not identify more than five attributes for each entity.

In a Microsoft Excel spreadsheet, define six columns (nouns) from the project description you submitted in W1 Assignment 3 that you consider key to your database. These will be the tables for the database. Then, in the rows for each column, define the attributes (adjectives).

You have taken your creative idea and started to move the nouns and adjectives you identified in a logical model—the E-R model. This will give you a working outline of the tables that will be created in the final script.

Assignment Deliverable

After you complete the lab and course project, collate the information from both in a 3- to 4-page report in a Microsoft Word document.

This is what I came up with.

Student { Student_ID, Student_name, Address, Contact_number, Course_interested_in}

The student might be interested in pursuing a specific course. Therefore, you need to store details about the courses available. For example:

Course { Course_ID, Course_name, Faculty_ID, Duration, number_of_seats}

Now, a course is taught by a faculty. We need to store details of the faculties. For example:

Faculty { Faculty_ID, Name, Course_ID, contact_number}

I need to make sure this is right. I need help with the Excel portion.

"Get 15% discount on your first 3 orders with us"
Use the following coupon

Order Now