Create the following tables ( primary keys are underlined). Bus ( Bus_no , capacity ,depot_name) Route (Route_no ,source ,destination ,no_of_stations ) Relationship : Bus-Route : M-1 Constraint : Bus capacity is not nul Create the above database in PostGreSQL and insert sufficient records. Database Management System (DBMS)

Create the following tables ( primary keys are underlined). Bus ( Bus_no , capacity ,depot_name) Route (Route_no ,source ,destination ,no_of_stations ) Relationship : Bus-Route : M-1 Constraint : Bus capacity is not nul Create the above database in PostGreSQL and insert sufficient records.

IT Comp Tutorials November 02, 2023

Read more
Create the following tables ( primary keys are underlined). Account ( acct_no ,acct_type, balance, branch_name) Customer (cust_no, cust_name, cust_city) Relationships : Customer-Account :1-M Constraints: acct_type can be “saving” or “current”, balance > 0 Create the above database in PostGreSQL and insert sufficient records. Database Management System (DBMS)

Create the following tables ( primary keys are underlined). Account ( acct_no ,acct_type, balance, branch_name) Customer (cust_no, cust_name, cust_city) Relationships : Customer-Account :1-M Constraints: acct_type can be “saving” or “current”, balance > 0 Create the above database in PostGreSQL and insert sufficient records.

IT Comp Tutorials November 02, 2023

Read more
Create the following tables ( primary keys are underlined). Emp (eno, ename, salary) Project (pno, pname, budget) Relationships: Emp– Project : M – M with descriptive attribute no-of-hrs Create the above database in PostGreSQL and insert sufficient records. Database Management System (DBMS)

Create the following tables ( primary keys are underlined). Emp (eno, ename, salary) Project (pno, pname, budget) Relationships: Emp– Project : M – M with descriptive attribute no-of-hrs Create the above database in PostGreSQL and insert sufficient records.

IT Comp Tutorials November 02, 2023

Read more
Create the following tables ( primary keys are underlined). Sales_order(s_orderno, s_order_date, order_amt) Client(client_no, name, address) There exists a one-to-many relationship between Client and Sales_order Constraints: order_amt > 0 Create the above database in PostGreSQL and insert sufficient records. Database Management System (DBMS)

Create the following tables ( primary keys are underlined). Sales_order(s_orderno, s_order_date, order_amt) Client(client_no, name, address) There exists a one-to-many relationship between Client and Sales_order Constraints: order_amt > 0 Create the above database in PostGreSQL and insert sufficient records.

IT Comp Tutorials November 02, 2023

Read more
Consider the following Doctor - Patient database (Primary keys are underlined) Doctor (doctor_code,doctor_name, specialization, address, phone_no) Patient (Patient_code, Patient_name, symptoms) There exists a one-to-many relationship between Doctor and Patient. Create the above database in PostGreSQL and insert sufficient records. Database Management System (DBMS)

Consider the following Doctor - Patient database (Primary keys are underlined) Doctor (doctor_code,doctor_name, specialization, address, phone_no) Patient (Patient_code, Patient_name, symptoms) There exists a one-to-many relationship between Doctor and Patient. Create the above database in PostGreSQL and insert sufficient records.

IT Comp Tutorials October 30, 2023

Read more