Using your knowledge of selecting entities and attributes, complete the followin

Question

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.

Explanation / Answer

While you are creating a database schema you should maintain normalization rules. But your entity attributes are somewhat correct even though normalization rules were not applied. Every table in the database should be relational.

Student {Student_ID, Student_Name, Phone_Number, Year, Course_ID}; -- Primary key(Sutdent_ID), Foreign key(Course_ID)

Course {Course_ID, Course_Name, Faculty_ID, Duration, Number_of_seats}; -- Primary key(Course_ID), Foreign key(Faculty_ID)

Faculty {Faculty_ID, Faculty_Name, Course_ID, Phone_Number}; -- Primary key(Faculty_ID), Foreign key(Course_ID)

Creating tables:

CREATE TABLE Student (

Student_ID number primary key,

Student_Name varchar2(20) not null,

Phone_Number number(10),

Year timestamp,

Course_ID number references Course

);

CREATE TABLE Course (

Course_ID number primary key,

Course_Name varchar2(20) not null,

Faculty_ID number references Faculty,

Duration number,

Number_of_seats number not null

);

CREATE TABLE Faculty (

Faculty_ID number primary key,

Faculty_Name varchar2(20) not null,

Course_ID number references Course,

Phone_Number number

);

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

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