Oracle / Database task

Lukket

Beskrivelse

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]

Færdigheder: Database Administration, Databaseudvikling, Programmering af database, Oracle

Se mere: 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

Projekt-ID: #13447926

32 freelancere byder i gennemsnit $85 for dette job

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!!

$150 USD in 3 dage
(110 bedømmelser)
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 Mere

$77 USD på 1 dag
(33 bedømmelser)
4.9
vinaysinghh

A proposal has not yet been provided

$111 USD in 5 dage
(30 bedømmelser)
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 Mere

$80 USD in 3 dage
(5 bedømmelser)
3.0
$305 USD in 8 dage
(9 bedømmelser)
3.2
$35 USD på 1 dag
(7 bedømmelser)
3.5
jagdishbhatt38

A proposal has not yet been provided

$133 USD in 5 dage
(6 bedømmelser)
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

$60 USD in 4 dage
(8 bedømmelser)
3.1
$30 USD på 1 dag
(2 bedømmelser)
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 Mere

$100 USD på 1 dag
(2 bedømmelser)
1.0
manojbansallx

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

$66 USD in 20 dage
(0 bedømmelser)
0.0
consultkasyap

worked on database design projects in the past

$55 USD in 2 dage
(0 bedømmelser)
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?

$50 USD på 1 dag
(0 bedømmelser)
0.0
prakashparmar79

A proposal has not yet been provided

$25 USD in 5 dage
(0 bedømmelser)
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.

$55 USD in 3 dage
(0 bedømmelser)
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 Mere

$350 USD in 3 dage
(0 bedømmelser)
0.0
$25 USD in 2 dage
(0 bedømmelser)
0.0
ybhupendra

A proposal has not yet been provided

$91 USD in 2 dage
(0 bedømmelser)
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 Mere

$50 USD in 7 dage
(0 bedømmelser)
0.0
salyhelmy18

have 4 years experience as oracle developer

$100 USD in 10 dage
(0 bedømmelser)
0.0