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.
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.
 Task Requirements Design a database for messenger system. The system contains

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!