Showing posts with the label Database Management System (DBMS)Show all
Consider the following Property – Owner database (Primary keys are underlined) Property (Property_no, area, location, city) Owner (owner_name, address, phone) The relationship is as follows: Property – Owner are related with M-1 relationship Create the above database in PostGreSQL and insert sufficient records. Database Management System (DBMS)

Consider the following Property – Owner database (Primary keys are underlined) Property (Property_no, area, location, city) Owner (owner_name, address, phone) The relationship is as follows: Property – Owner are related with M-1 relationship Create the above database in PostGreSQL and insert sufficient records.

IT Comp Tutorials November 02, 2023

Read more
Consider the following Student-Teacher database. Student (sno ,s_name, s_class)s_class can be either "FY", "SY" or "TY" Teacher (tno ,t_name, yrs_experience ) The relationship is as follows: Student-Teacher: M-M with descriptive attribute Subject. Create the above database in PostGreSQL and insert sufficient records. Database Management System (DBMS)

Consider the following Student-Teacher database. Student (sno ,s_name, s_class)s_class can be either "FY", "SY" or "TY" Teacher (tno ,t_name, yrs_experience ) The relationship is as follows: Student-Teacher: M-M with descriptive attribute Subject. 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). Game (gname, noofplayers, coachname, captain_name) Player (pno, pname) There exists a one-to-many relationship between Game and Player. Add constraint uppercase to captain_name Create the above database in PostGreSQL and insert sufficient records. Database Management System (DBMS)

Create the following tables ( primary keys are underlined). Game (gname, noofplayers, coachname, captain_name) Player (pno, pname) There exists a one-to-many relationship between Game and Player. Add constraint uppercase to captain_name 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). 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