HomeworkLib
Question


7. The transformation of an E-R model to a relational model is shown in the follow- ing. Is this transformation correct? If n

Student StudentID StudentName Address Dependent DependentID DateOfBirth StudentID
engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Converting ER Diagram into Relational Tables:

Step 1: Convert Strong Entities into relational tables.Here strong entity is Student. So

CREATE TABLE STUDENT(StudenId INT PRIMARY KEY,StudentName CHAR(20),Address char(20))

Step 2: Convert Weak Entities into relational tables.Here weak entity is Dependent. So

CREATE TABLE DEPENDENT(DependentID int,dateOfBirt date)

Step 3: Add binary key 1:1,1:N,M:N Relationships to table.

Here in given ER Diagram it is showing that one student have many dependents.

In that case Add One side Prime Attribute to N side entity and make it as a foreign key. i.e StudentId int Dependent table refers the StudentId in Student Table .

ALTER TABLE DEPENDENT ADD StudentId INT

ALTER TABLE DEPENDENT ADD FOREIGN KEY(StudentId) References STUDENT(StudenId)

So whatever given relations are perfectly fine. The transformation from ER Model to Relational model is correct.

Note : if you have any queries please post a comment thanks a lot..always available to help you...

1 0
Add a comment
Know the answer?
Add Answer to:
7. The transformation of an E-R model to a relational model is shown in the follow-...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Question II TRANSFORM THE E-R Diagram into the Relational Model Please convert the E-R diagram below...

    Question II TRANSFORM THE E-R Diagram into the Relational Model Please convert the E-R diagram below to a relational model. · E-R diagram for customers and loans: name street_address ( loan id (access_date) amount cust_id - city ) customer borrower loan

  • This assignment your tasks is to convert the E-R diagram to a relational model and then...

    This assignment your tasks is to convert the E-R diagram to a relational model and then to SQL. The mapping process is straightforward. Three components of the conversion process are Specify schema of relation itself Specify primary key on the relation Specify any foreign key references to other relations 1. 2. 3. dateBorn mName birthPlace IName dateDied fName IName address - oCountry ID mName ttlAmt Customers N Artists M Favors fName artStyle ID N Creates Like M startedDate theme title...

  • Using this picture of an E-R diagram convert it to the relational model. Also if making the E-R diagram to an EE-R diag...

    Using this picture of an E-R diagram convert it to the relational model. Also if making the E-R diagram to an EE-R diagram relational model what would differ? Please explain in most simplistic way. Appointment Patlent 4 Insurance Pollcy Staff Visit Room Payment Bil Prescripion Script Avalability Procedure Charge Diagnosis Referral Performed Prescription LabTest Medcation Procedures Diagnosis Menu Menu Appointment Patlent 4 Insurance Pollcy Staff Visit Room Payment Bil Prescripion Script Avalability Procedure Charge Diagnosis Referral Performed Prescription LabTest Medcation...

  • Database: Convert E-R diagrams to relational schema and show • Primary Keys (using underline) • Foreign Keys (using dotted underline) • Referential Integrity Convert the E-R diagrams to relational s...

    Database: Convert E-R diagrams to relational schema and show • Primary Keys (using underline) • Foreign Keys (using dotted underline) • Referential Integrity Convert the E-R diagrams to relational schema and show: Primary Keys (using underline) Foreign Keys (using dotted underline) . Referential Integrity Your schema should look similar to the example below. CUSTOMER CustName ORDER PROJECT Foect Title EMPLOYEE PROJECT assigecl to Tite BBli EMPLOYEE PROJECT 0 ProectTitle 4 student admitdate D,C gradstudent advisor major mimor class person name...

  • Transform the E-R model into a relation model Sign In Date Customer ID Service ID Sign...

    Transform the E-R model into a relation model Sign In Date Customer ID Service ID Sign Name Type Service Customer Address Description Classification Pay Min Monthly Charge Consumed Units Per Month Rate Per Unit Due Date Pay Date

  • E-R model creation help I need help creating a E-R model for a healthcare. In the...

    E-R model creation help I need help creating a E-R model for a healthcare. In the hospital, there are several rooms. Each room has an ID general description of equipment in rooms.Each room can be scheduled with multiple test and each IR test will be scheduled and conducted in only one room. The test, will be a key(encounter number) displays the associated date of service, provider and time of appointment which will key. It included the start time and end...

  • In C++ Language: In the following problems assume the iostream library has been included and that...

    In C++ Language: In the following problems assume the iostream library has been included and that you are using the namespace std. 1. Define a struct for a recreational vehicle with the following members: year (int), length (float), width (float), height (float), weight (float), make (string), model (string), luxuryStyling (bool), color (string), retailPrice (float). 2. Consider the following statements. Although it may be confusing, it is legal to have name as the identifier of a one struct and separately as...

  • Questlon 2: Relationships -20 marks Consider the following 3NF relations about a sorority or fraternity: MEMBER(Member_ID, Name, Address, Dues_ Owed) OFFICE(Office_Name, Officer_ID, Term_Start_Da...

    Questlon 2: Relationships -20 marks Consider the following 3NF relations about a sorority or fraternity: MEMBER(Member_ID, Name, Address, Dues_ Owed) OFFICE(Office_Name, Officer_ID, Term_Start_Date, Budget) EXPENSE(Ledger_Number, Office Name, Expense_Date, Amt_Owed) PAYMENT(Check_ Number, Expense_Ledger Number, Amt Paid) RECEIPT(Member_ID, Receipt_Date, Dues_Received) COMMITTEE(Committee ID, Officer_in_Charge) WORKERS(Committee_ID, Member_ID) Foreign keys are not indicated in these relations. Decide which attributes are foreign keys and justify your decisions. (6 marks) Draw an E-R diagram for these relations, using your answer in part a. (6 marks) Explain the...

  • I am practicing to draw the E-R diagram for this question, help me to get a...

    I am practicing to draw the E-R diagram for this question, help me to get a correct answers please. thank you for your help! A university faculty staff members who are involved in teaching the units offered by the faculty. By considering the following information, draw an diagram for this faculty. (For drawing the diagram, you can make any assumptions you need, but state all your assumptions clearly in your answer): stores the necessary information about the academic Entity-Relationship Each...

  • (TCO 7) Write a JOIN to display the instructor first and last names and the course...

    (TCO 7) Write a JOIN to display the instructor first and last names and the course description for the course the instructor is teaching Student Instructor Zipcode PK Student ID PK Instructor ID PK Zip Salutation First Name Last Name Street Address Phone Employer Registration Date Salutation First_Name Last_Name Street Address City State FK1 Zip FK1 Zip Section PK Section ID Course Course Section_Num Enrollment Start Date_Time Location PK Course ID PK,FK1 Section ID PK,FK2 Student ID Capacity FKI |...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT