Question: 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.
Create all the required tables for the system.
Add records for eaich table using DML commands.
Update record from each table using DML commands.
Delete record from each table using DML commands.
Modify of the table's names using DDL commands.
Modify columns' names with their datatypes using DDL commands.
Create the class diagram for the system.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
