Answered step by step
Verified Expert Solution
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.
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. * 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_descriptionStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started