Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Task Requirements Design a database for messenger system. The system contains many users that can send messages to each other, and each user has his

Task Requirements
Design a database for messenger system. The system contains many users that
can send messages to each other, and each user has his own profile that contains information about him. This system has many services, and the users can use these services when they buy them, each user can buy more than one service.
(Note that every payment for any service is stored on the database).
Draw the ER diagram or Schema diagram for the previous scenario.
2- Create all the required tables for the system.
Add 3 records for eaich table using DML commands.
Update 1 record from each table using DML commands.
Delete 1 record from each table using DML commands.
Modify 1 of the table's names using DDL commands.
Modify 2 columns' names with their datatypes using DDL commands.
Create the class diagram for the system.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions