Closed

uni work database

1) Design a conceptual schema (using UML notation) from the above descrip- tion (7 Marks)

2) Give the logical relational schema for the database including all constraints for all involved relations. Apply the necessary normalization (if required) to eliminate any redundancy from the relations (7 Marks)

3) Give the Oracle SQL DDL statements to create the tables corresponding to the relations in your logical schema including all the necessary constraints (7 Marks)

3 Marks will be given if the design reads as one cohesive design, i.e. the

logical schema is a valid translation of the corresponding conceptual schema and the physical schema is a valid translation of the relational schema. One mark will be given for clarity of the report.

Skills: Database Administration, Database Development, Database Programming, Oracle, SQL

See more: oracle sql ddl create table, oracle sql ddl script, foreign key oracle sql ddl, oracle sql ddl tables, oracle sql select statements, oracle sql ddl create examples, oracle sql command database create, oracle sql ddl, create oracle database tables using sql ddl, oracle desginer ddl statements model, oracle sql decimal statements, oracle sql statement select employees database work projects, oracle sql order statements, oracle sql date statements, oracle exists ddl statements

About the Employer:
( 0 reviews ) United Kingdom

Project ID: #15686266

16 freelancers are bidding on average £19/hour for this job

truongnguyen86

Hi there, i'm expert on designing the database include: chen notation, crow foot, uml notation...Your work is to design the DB for manager sandwich orders for Brizzle Sarnies, it require to create the ERD with UML, con More

£15 GBP / hour
(163 Reviews)
6.6
asadrana91

Hi there, I have considerable experience with sql work. If you need a high grade, contact me now. You need normalization concepts implementations as well or just the database?

£14 GBP / hour
(33 Reviews)
5.9
point5nyble

Hello, I have been working as an IT BI DWH Professional since last ~ 7 years, as an. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my tale More

£11 GBP / hour
(47 Reviews)
5.2
jlsproject

I have more than 10 years experience in Oracle. You can look at my success projects in history. Can you name UML tool, you use?

£15 GBP / hour
(24 Reviews)
4.6
vinaysinghh

i am oracle dba having more then 10 yrs of exp.i can do this task in 2 days........................................................................................

£11 GBP / hour
(49 Reviews)
5.3
maxpl

Hi, Please let me know if you are available, I will show you demo of similar project, front end and backend system. Please check my profile : I am a full stack developer from Poland, I have 6+ years of expe More

£13 GBP / hour
(1 Review)
4.5
murtaza1981

Hi, An ASP.NET, c#, vb, [url removed, login to view], NopCommerce, JQuery, JavaScript, SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) expert here. Please fe More

£15 GBP / hour
(2 Reviews)
4.0
mlsokolova

Hello Probably I could help you I have a question: What tools do you prefer for creating UML and Logical Schema?

£13 GBP / hour
(8 Reviews)
3.4
techwelfare

Hello, We are working for this industry for last 10 years, Please reply us back so we could share our relevant skill and start working. Thanks & Regards Techwelfare

£12 GBP / hour
(6 Reviews)
3.5
lifekicked

Hello! Greetings Sound knowledge in database design with demonstration ability. would complete your project as per to documentation provided in pdf. regards syed

£16 GBP / hour
(1 Review)
2.0
ranashweta

expert in database

£16 GBP / hour
(0 Reviews)
0.0
miguecg

A proposal has not yet been provided

£11 GBP / hour
(0 Reviews)
0.0
abubakar4248

Hi i'm a professional software engineer i have +3 years experience in this field i have lot of expertise in Database development using SQL server, MySql and Oracle i have also expertise in Stored procedure, Trigger More

£10 GBP / hour
(0 Reviews)
0.0
£13 GBP / hour
(0 Reviews)
0.0
zakroq

A proposal has not yet been provided

£11 GBP / hour
(0 Reviews)
0.0
mehulrastogi87

A proposal has not yet been provided

£100 GBP / hour
(0 Reviews)
0.0