Question: we want the SQL code for this ERD diagram please 1..1 1..* Student Staff 1..1 S_MatricNo. Staff_id Name Program S firstname 1..* 1..* P_Code Staff_name

we want the SQL code for this ERD diagram please

1..1 1..* Student Staff 1..1 S_MatricNo. Staff_id Name Program S firstname 1..* 1..* P_Code Staff_name 1. * first_name Staff_Gender Staff_DOB position P_Name 0..* S_lastname S_DOB S_Gender Department Phone No. 0..* P_Catagore Role TAXI 1. * TaxiDriverName Year Srart_date End_date (Mondatory, Or) Room_ID Taxi DriverCarNo. TaxiDriverPhoneNO S Name 1..1 Hostel_Owner Department_accountant DA_id DA_FirstName Manager_id Manager_DOB Manager_firstname Manager_lastname Manager Gender Position 0..1 Room DA_LastName S_Department - Student_Year Room_id Reciept_payment 0.. Room_id Library Room_no BookNo. Room_Price Room_Description Room_state Book_ld Book_name

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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)...

please help me with this as my tutor fell through and I dont understand all sections these are the programs it gave me this is the main java above this is the grade book reader above these are the...

A discrete sequence {xn} can be converted into a continuous representation x(t) = ts X n= (t n ts) xn, where ts is the sampling period. (a) State two characteristic properties of Dirac's function. [2...

Mates Rates Rent-A-Car ( just do the part a) using visual studio code (C#) Criteria sheet - Par A Example supplementary files (readme.pdf) Example supplementary files (class-diagram.pdf) Assignment...

I need the ERD (Entity Relationship Diagram) in third nominal form. All information I have is provided. MILESTONE 3 - DATA MODEL NORMALIZATION Synopsis In this milestone you will develop a normalized...

I Want the SQL CODE for these diagrams below & a Screenshot of the output ER DIAGRAM MAP DIAGRAM I want if you can correct the error if there is an error in the diagrams that I made (ER DIAGRAM, MAP...

CI want the sql code for each qustionreate a list of all Florida and Georgia customers. Display all the customer's information. Display the information of customers who were born in 1 9 7 6 . Count...

What is the purpose of the AS clause in SQL? It defines a search condition It assigns aliases to tables, columns, or calculations It is used in INNER JOIN to join two tables Neither of the other...

1 2 Figure 1 . If you cannot see above figure 1 , download it here darr. Q 1 - 1 ( 2 points ) We would like to create MySQL ' s codes for seven ( 7 ) entities and relationships, as the ERD presents...

Write the SQL code for the following: List the class name, room, location, day, and time for all classes. Write the SQL code for the following: Display the last names of the customers who have...

Three mutually exclusive projects, Project A, Project B, and Project C, are being considered for investment at a MARR of 10%. The three investments are explained in the table below. Answer the...

Little Corp. was experiencing cash flow problems and was unable to pay its $ 105,000 account payable to Big Corp. when it fell due on September 30, 2014. Big agreed to substitute a one-year note for...

At year end, a partner's drawing account Multiple choice question. is closed to the partner's capital account. remains open to accumulate partner withdrawal throughout the life of the partnership. is...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Recognize the important role customer loyalty plays in driving a service firms profitability.

Explain the qualities of effective leaders in service organizations.

Understand why customers are loyal to a particular service firm.