100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
ICT3722 Assignment 4 memo 20024 $4.84   Add to cart
Quickly navigate to
Preview
  2.  
  3. University Of South Africa (Unisa)
  4.  
  5. Database Practice - ICT3722 (ICT3722)

Other

ICT3722 Assignment 4 memo 20024
 6 views  0 purchase
  • Course
  • Database Practice - ICT3722 (ICT3722)
  • Institution
  • University Of South Africa (Unisa)

ICT3722 Assignment 4 memo 20024: Scenario: Batho Pele is a local NGO dedicated to providing support and care for old age pensioners in the community. The organisation struggles with keeping accurate records of its beneficiaries, including their personal information, health needs, medications, per...

[Show more]

Preview 2 out of 9  pages

Document information

  • July 25, 2024
  • 9
  • 2023/2024
  • Other
  • Unknown

Subjects

  • ict3722

Written for

  • University of South Africa (Unisa)
  • Database Practice - ICT3722 (ICT3722)
All documents for this subject (2)

Seller

avatar-seller
foxNotes

Reviews received

Content preview

Question1




Question 2
CREATE TABLE Beneficiaries(
BeneficiaryID NUMBER(3) PRIMARY KEY NOT NULL,
Name VARCHAR2(50) NOT NULL,
Age NUMBER(3) NOT NULL,
Gender VARCHAR2(10) NOT NULL,
Address VARCHAR2(100) NOT NULL,
ContactNumber VARCHAR2(12) NOT NULL,
NextOfKinID NUMBER(3) NOT NULL
);


INSERT INTO Beneficiaries (BeneficiaryID, Name, Age, Gender,
Address, ContactNumber, NextOfKinID)
VALUES (1, 'John Doe', 75, 'Male', '123 Main Street', '555-123-
4567', 101);

INSERT INTO Beneficiaries (BeneficiaryID, Name, Age, Gender,
Address, ContactNumber, NextOfKinID)
VALUES (2, 'Jane Smith', 80, 'Female', '456 Elm Avenue', '555-987-
6543', 102);

INSERT INTO Beneficiaries (BeneficiaryID, Name, Age, Gender,
Address, ContactNumber, NextOfKinID)
VALUES (3, 'Michael Lee', 70, 'Male', '789 Oak Street', '555-321-
7890', 103);

INSERT INTO Beneficiaries (BeneficiaryID, Name, Age, Gender,
Address, ContactNumber, NextOfKinID)

, VALUES (4, 'Mary Brown', 85, 'Female', '101 Pine Road', '555-456-
7890', 104);

INSERT INTO Beneficiaries (BeneficiaryID, Name, Age, Gender,
Address, ContactNumber, NextOfKinID)
VALUES (5, 'David Clark', 78, 'Male', '202 Cedar Lane', '555-789-
0123', 105);

INSERT INTO Beneficiaries (BeneficiaryID, Name, Age, Gender,
Address, ContactNumber, NextOfKinID)
VALUES (6, 'Sarah Taylor', 82, 'Female', '303 Maple Drive', '555-
345-6789', 106);

INSERT INTO Beneficiaries (BeneficiaryID, Name, Age, Gender,
Address, ContactNumber, NextOfKinID)
VALUES (7, 'James Wilson', 75, 'Male', '404 Birch Street', '555-
678-9012', 107);

INSERT INTO Beneficiaries (BeneficiaryID, Name, Age, Gender,
Address, ContactNumber, NextOfKinID)
VALUES (8, 'Linda Martinez', 77, 'Female', '505 Oakwood Blvd',
'555-890-1234', 108);

INSERT INTO Beneficiaries (BeneficiaryID, Name, Age, Gender,
Address, ContactNumber, NextOfKinID)
VALUES (9, 'Robert Nguyen', 73, 'Male', '606 Walnut Avenue', '555-
234-5678', 109);

INSERT INTO Beneficiaries (BeneficiaryID, Name, Age, Gender,
Address, ContactNumber, NextOfKinID)
VALUES (10, 'Emily Harris', 79, 'Female', '707 Pinehurst Lane',
'555-456-7890', 110);

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller foxNotes. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $4.84. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

67866 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$4.84
  • (0)
  Add to cart