Question 1 [Out of 50]

Suppose that we have a relational database, dbCRM, with the following tables.

tblcustomers

Customer_id	First_Name	Surname	Email	National_ID
0001	Chemson	Mukange	chemsonmukange@.com	04-0000K-09
0002	Chayne	Matambo	chaynematambo@yahoo.com	63-9999Z-78
0003	Chaim	Maguraushe	chaimmg@tsamail.co.za	27-7878T-27

tblcomplains

Complain_ID	Complain_Date	Customer_ID	Complain_Details
CID9000	2022-01-31	0003	Expired bread
CID9001	2022-02-10	0004	Wet Birth Day Cards
CID9002	2022-08-13	0001	Expired Snacks

tblcomplain_resolve

Complain_Resolve_ID	User_ID	Date_Resolved	Complain_ID	Resolve_Details
CR0003	0909	2022-01-31	CID9000	Bread Replaced
CR0003	8000	2022-02-25	CID9001	Refund

tblusers

User_ID	Username	Password
0909	mildred	Xxxi@7878
8000	miriro	Vimb8987@