Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

we need the SQL query code for this ERD diagram to create the table please 1..1 Bailsman Hostel Owner Bailsman_name Bailsman_position Bailsman_phone Bailsman_city Bailsman_email 1.

image text in transcribedwe need the SQL query code for this ERD diagram to create the table please

1..1 Bailsman Hostel Owner Bailsman_name Bailsman_position Bailsman_phone Bailsman_city Bailsman_email 1. * Manager_ID (PK) Manager_DOB Manager Gender Manager_firstname Manager_lastname position 1..1 1..1 1..1 1..1 Student 1..* 1..* S_matrixNo (pk) Name S_firstname S_lastname sex Department Year PhoneNo Room_id Email 1..1 Admin Staff_id (pk) staff_name first_name last_name Staff_gender Staff DOB position emaill Program P_code(pk) 1. P_name P_categore Role Start_date End_date 0..* 1.1 1..1 0..1 Room Room_id Room_no Room_price Room_description Room_state Room_place Room_city Department Accountant Da_ID (PK) Da_FIRSTName Da_lastName receipt_payment student_year student_name Room_id Room_Price Cooking Room Cook_id Cook_price Cook_name Cook_menu Cook_description 1..1 Bailsman Hostel Owner Bailsman_name Bailsman_position Bailsman_phone Bailsman_city Bailsman_email 1. * Manager_ID (PK) Manager_DOB Manager Gender Manager_firstname Manager_lastname position 1..1 1..1 1..1 1..1 Student 1..* 1..* S_matrixNo (pk) Name S_firstname S_lastname sex Department Year PhoneNo Room_id Email 1..1 Admin Staff_id (pk) staff_name first_name last_name Staff_gender Staff DOB position emaill Program P_code(pk) 1. P_name P_categore Role Start_date End_date 0..* 1.1 1..1 0..1 Room Room_id Room_no Room_price Room_description Room_state Room_place Room_city Department Accountant Da_ID (PK) Da_FIRSTName Da_lastName receipt_payment student_year student_name Room_id Room_Price Cooking Room Cook_id Cook_price Cook_name Cook_menu Cook_description

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Handbook Of Relational Database Design

Authors: Candace C. Fleming, Barbara Von Halle

1st Edition

0201114348, 978-0201114348

More Books

Students also viewed these Databases questions

Question

technologies on organizations.

Answered: 1 week ago

Question

1. Who will you assemble on the team?

Answered: 1 week ago

Question

Did the team members feel that their work mattered

Answered: 1 week ago