use SQL to solve this question

this is all the information i have kindly solve this

Part 1: Data Design, Data Definition and Insertion using Oracle SQL Plus (40%) Logical Conceptual Data Model From the identified system websites/sources describe the business model, table schema; and (10 marks) create data model (entity relationship diagram) for the chosen database system using CASE tools (Lucidchart, Visio, etc). Name the database system. (10 marks) . Physical Data model Create appropriate tables using CREATE TABLE commands. For each table clearly define all attributes, their data types, initial values and integrity rules. Define all primary keys and foreign key identifiers with appropriate restrictions. (20 marks) Example Table Name DEPTS Cricate table CREATE TABLE Depes Day No SMALLINT myley Depe_Name VARCHARTS NOT NULLX ALTERTARLE Depes ADD CONSTRAINT PRIMARY KEY Tahle Name Create the TheN Create the Describe able Insert realistic data into the tables to ensure you can create meaningful queries. - List the exact SQL code to insert rows into the tables. (5 marks) For each table, display the contents for all the tables using appropriate SELECT statement (5 marks) Example Table Name DEPTS Inertitel: INSERT INTO DE VALLESEL INSERT INTO VALUES. Mit INSERT INTO VALLES Display all from hele SOL SELECTRODOTS: DET NO DEFE ACCOUNT marketing sales Table Name Inserite: Display all from the le Tuhle Na In the Display all the Tone Nam Display all from the tohle Tube Now wiele Diply alt frem 7 Contents Part 1: Data Design, Data Definition and Insertion using Oracle SQL Plus (40%) 3 a. Logical/Conceptual Data Model 3 b. Physical Data model 3 c. Insert realistic data into the tables to ensure you can create meaningful queries. 6