"6.1,6.2,6.1 are answered" Note: Since you have posted multiple sub-questions in the same request, we will solve the first three questions for you. To get the remaining questions solved, please repost...

"6.1,6.2,6.1 are answered"

Note: Since you have posted multiple sub-questions in the same request, we will solve the first three questions for you. To get the remaining questions solved, please repost other questions independently.

Database management systems store records about separate related entities and manage them efficiently. Also, they provide mechanisms to fetch those values when required. DML/DDL/DCL queries can be formed to create/destroy relations, fetch data from one or more relations, etc.

Storing data and information using the database systems is secure and time-convenient. Relations are optimized or normalized so that no data loss or unnecessary data modification occurs in the database.

Answer:

6.1. There are four tables in this database system Doctor, Patient, Consultation, and Practice. The tables are designed with the defined attributes as:

Syntax:

CREATE TABLE TABLE-NAME(FIELD1 TYPE, FIELD2 TYPE, ...);

CREATE TABLE Patient(Pat_ID varchar(4) primary key,
Pat_name varchar(50),
Pat_age number,
Pat_gender varchar(4));

CREATE TABLE Practice(Prc_ID varchar(4) primary key,
Prc_name varchar(50),
Prc_yearestablished number,
Prc_province varchar(20));

CREATE TABLE Doctor(Doc_ID varchar(4) primary key,
Doc_name varchar(50),
Doc_employdate date,
Prc_ID varchar(4),
FOREIGN KEY (Prc_ID) REFERENCES Practice(Prc_ID));

CREATE TABLE Consultation(Doc_ID varchar(4),
Pat_ID varchar(4),
Con_date date,
primary key(Doc_ID,Pat_ID),
FOREIGN KEY (Pat_ID) REFERENCES Patient(Pat_ID),
FOREIGN KEY (Doc_ID) REFERENCES Doctor(Doc_ID));

 Schema:

6.2. Adding two records in each table:

For adding records, the insert query should be used.

insert into Patient values('P001','Patient1',45,'M');
insert into Patient values('P002','Patient2',32,'F');

insert into Practice values('Pr01','Practice1',2010,'Gauteng');
insert into Practice values('Pr02','Practice2',2015,'Luxemberg');

insert into Doctor values('D001','Alam',date '2018-04-01','Pr01');
insert into Doctor values('D002','Abedin',date '2021-01-20','Pr02');

insert into Consultation values('D001','P002',date '2020-09-20');
insert into Consultation values('D001','P001',date '2021-01-24');

6.1. To show the TrueHealth practices in the location 'Gauteng', the select statement should be used providing the correct condition.

select * from Practice where Prc_province='Gauteng';

The practice records for the province "Gauteng" will be displayed. Again, you can show only the name of the practices mentioning the field name.

select Prc_name from Practice where Prc_province='Gauteng';