Oracle ERD and DDL Queries -- 2
Budget: $30 – $250 USD
I am wrapping up an academic Oracle 19c project that models a Travel Jabs Clinic and still need polished, university-ready material—especially on the Data Definition side. The grade weight falls on showing clear, well-structured CREATE TABLE statements, so writing concise, standards-compliant DDL is the heart of the work.
Here is what remains:
• A UML-notation ER diagram that reflects a fully normalised schema
• A data dictionary mapping every attribute, type, and constraint
• Clean CREATE TABLE scripts—including primary, foreign, check and NOT NULL constraints—that execute without warnings in SQL*Plus or SQL Developer
• Populated sample data (≈10 representative rows per table) to support demonstrations
• Three meaningful SQL scripts focused on Data Definition, each showcasing table creation for key clinic components, accompanied by screenshots of successful execution and brief commentary
• A short narrative explaining entity, referential and column-level constraints and how they satisfy clinic requirements
• A collated report formatted for university submission, tying ERD, scripts, outputs and explanations together
Acceptance criteria: every script runs error-free on first execution; screenshots exactly match the provided scripts; documentation is plagiarism-safe and follows academic referencing conventions.
If you are comfortable crafting crisp DDL, illustrating constraints, and packaging everything in a clear, academic tone, this project should be straightforward and quick to finalise.
Here is what remains:
• A UML-notation ER diagram that reflects a fully normalised schema
• A data dictionary mapping every attribute, type, and constraint
• Clean CREATE TABLE scripts—including primary, foreign, check and NOT NULL constraints—that execute without warnings in SQL*Plus or SQL Developer
• Populated sample data (≈10 representative rows per table) to support demonstrations
• Three meaningful SQL scripts focused on Data Definition, each showcasing table creation for key clinic components, accompanied by screenshots of successful execution and brief commentary
• A short narrative explaining entity, referential and column-level constraints and how they satisfy clinic requirements
• A collated report formatted for university submission, tying ERD, scripts, outputs and explanations together
Acceptance criteria: every script runs error-free on first execution; screenshots exactly match the provided scripts; documentation is plagiarism-safe and follows academic referencing conventions.
If you are comfortable crafting crisp DDL, illustrating constraints, and packaging everything in a clear, academic tone, this project should be straightforward and quick to finalise.