Oracle / Database task

Kapalı

Açıklama

Part A: Step 1 (25 marks) Create a logical (relational) data model (e.g. Database or ER diagram). Use J Developer or Visio to create this diagram.

Use appropriate naming conventions while naming tables, attributes, relationships, etc. Also use appropriate data-types, data-sizes, etc. in the diagram and ensure to flag PKs, FKs, etc. There should be two business rules for each relationship (association) shown on diagram. State these business rules very clearly under a separate section (in your report). Similarly, state your reasonable assumptions (this helps us better evaluate your design) under a separate section. Examine each table’s (entity’s) attributes for dependencies and apply the rules of normalisation discussed in Chapter 6 of the textbook. You are required to show the detailed normalisation process {e.g. how you move from lower normal form (e.g. 1NF) to the next (e.g. 2NF)} in the submitted work. Use dependency diagrams for depicting all the relationships among a table’s attributes. Normalise tables up to the highest possible NF.

Part A: Step 2 (9 marks) Generate physical model based on the logical model created in the Step 1. To create the required set of tables, relationships, constraints, etc. write SQL scripts using a text editor (e.g. Notepad). Use SQL Developer for initial checking / debugging and running of the code. Keep improving your code until you are happy with the design. Check carefully the DDL code in your script file and make sure that all the attribute definitions (e.g. names, data types, data sizes, domain values including defaults, etc.), table constraints (entity integrity, referential integrity, etc.), etc. are specified correctly

Validate your work by ensuring that query transactions {(a) – (p) listed towards the end of the case study} are supported by your design. Make sure that the physical design is a robust one and meets the requirements of a good design and remember normalisation alone does not produce a good design. In the end, ensure that both logical and physical designs are consistent with each other. Run your final scripts to generate the database (i.e. physical model). Use your Group Oracle a/c to implement the final code.

Part A: Step 3 (6 marks) Now create appropriate test data to populate the tables you created in Step2. You can use SQL Developer to run a script file that contains SQL INSERT statements or directly enter data. There should be reasonably sufficient number of rows of test data across all the tables but no table should contain less than five rows. Make sure your test data appropriately and sufficiently reflects (this could sometimes mean adding more than 5 rows in some tables) and does not violate any of the constraints declared while creating the database. Set up all the tables and their constraints in the correct order before you load any data into the database.

For more details

please check

[url removed, login to view]

Beceriler: Veri Tabanı Yönetimi, Veritabanı Geliştirme, Veritabanı Programlama, Oracle

Daha fazlasını görün: list database oracle sqlplus, openerp database oracle possible, sqlplus create database oracle, convert mssql database oracle, openerp database oracle, tsa database oracle, osdate database error occured check query andor connection, fusioncharts database oracle, database oracle farsi php, oracle displaying name query, oracle increase date query, thiscrystalreport11database connection database oracle, convert sqlserver database oracle, database table parent child query, attendance system database oracle, example student record database oracle, ranking database oracle sql server db2 postgresql, database oracle labview, database error occured check query andor connection osdate

Proje NO: #13447926

32 freelancer bu iş için ortalamada 85$ teklif veriyor

truongnguyen86

Hello there, i'm expert on database designing also implementation on Oracle, let me help you with this. Waiting for your response if interested. Thank you!!

in 3 gün içinde150$ USD
(110 Değerlendirme)
6.2
point5nyble

Hello, I have been working with a MNC based company since last ~ 6 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in Daha fazlası

1 gün içinde 77$ USD
(33 Değerlendirme)
4.9
vinaysinghh

A proposal has not yet been provided

in 5 gün içinde111$ USD
(30 Değerlendirme)
4.7
enterpriseit1

Hi, I can do all that is listed in the description. I have done this work before. But to be honest the budget of 30 is just so low for that kind of work. I can do this for around $80 in 3 days. Let me know if you ne Daha fazlası

in 3 gün içinde80$ USD
(5 Değerlendirme)
3.0
in 8 gün içinde305$ USD
(9 Değerlendirme)
3.2
1 gün içinde 35$ USD
(7 Değerlendirme)
3.5
jagdishbhatt38

A proposal has not yet been provided

in 5 gün içinde133$ USD
(6 Değerlendirme)
2.9
abdulrehman57

Hello, My name is Abdul Rehman. I have much experience to design and develop the Database with using SQL server and ORACLE. i also design ERD in both SQL and ORACLE. Kindly inbox me for further queries. Thanks

in 4 gün içinde60$ USD
(8 Değerlendirme)
3.1
1 gün içinde 30$ USD
(2 Değerlendirme)
2.1
RajatVaghani

Hey there! I've read your project description. I think this is an excellent opportunity for me to showcase my expertise and for you to get the job done. My bid is at an extremely moderate price for this project. Als Daha fazlası

1 gün içinde 100$ USD
(2 Değerlendirme)
1.0
manojbansallx

i have over 6 years of experience working as oracle developer and have worked in leading IT companies like TCS

in 20 gün içinde66$ USD
(0 Değerlendirme)
0.0
consultkasyap

worked on database design projects in the past

in 2 gün içinde55$ USD
(0 Değerlendirme)
0.0
unicaweb

Hi, I am an Oracle and PL / SQL expert, OCA and OCP certified. It could carry out your project. Contact us to start and give me all the information. What would be the type of access to the environment?

1 gün içinde 50$ USD
(0 Değerlendirme)
0.0
prakashparmar79

A proposal has not yet been provided

in 5 gün içinde25$ USD
(0 Değerlendirme)
0.0
priyankakadle

experience in handling datawarehousing projects end to end right from design to production deployment and post-production support. Dealing with multiple data models.

in 3 gün içinde55$ USD
(0 Değerlendirme)
0.0
sukhwinder7979

• Strong Expertise Of Oracle Database. • 10+ years of Strong SQL, PL/SQL Experience. Created Tables, Views, Stored Procedures, Cursors, Functions, Packages, Triggers, Sequences and Dynamic SQL. • Strong Expertise of Daha fazlası

in 3 gün içinde350$ USD
(0 Değerlendirme)
0.0
in 2 gün içinde25$ USD
(0 Değerlendirme)
0.0
ybhupendra

A proposal has not yet been provided

in 2 gün içinde91$ USD
(0 Değerlendirme)
0.0
kbilalsalim

I have over fifteen years of database design, development and administration experience using oracle database (8 to 11g) and different other tools. Started as a trainee developer to work with forms and reports and that Daha fazlası

in 7 gün içinde50$ USD
(0 Değerlendirme)
0.0
salyhelmy18

have 4 years experience as oracle developer

in 10 gün içinde100$ USD
(0 Değerlendirme)
0.0