Oracle / Database task

Ditutup

Huraian

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]

Kemahiran: Pentadbiran Pangkalan Data, Pembangunan Pangkalan Data, Pengaturcaraan Pangkalan Data, Oracle

Maklumat lanjut: 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

ID Projek: #13447926

32 pekerja bebas membida secara purata $85 untuk pekerjaan ini

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 dalam 3 hari
(110 Ulasan)
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 Lagi

$77 USD dalam sehari
(33 Ulasan)
4.9
vinaysinghh

A proposal has not yet been provided

$111 USD dalam 5 hari
(30 Ulasan)
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 Lagi

$80 USD dalam 3 hari
(5 Ulasan)
3.0
$305 USD dalam 8 hari
(9 Ulasan)
3.2
$35 USD dalam sehari
(7 Ulasan)
3.5
jagdishbhatt38

A proposal has not yet been provided

$133 USD dalam 5 hari
(6 Ulasan)
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 dalam 4 hari
(8 Ulasan)
3.1
$30 USD dalam sehari
(2 Ulasan)
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 Lagi

$100 USD dalam sehari
(2 Ulasan)
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 dalam 20 hari
(0 Ulasan)
0.0
consultkasyap

worked on database design projects in the past

$55 USD dalam 2 hari
(0 Ulasan)
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 dalam sehari
(0 Ulasan)
0.0
prakashparmar79

A proposal has not yet been provided

$25 USD dalam 5 hari
(0 Ulasan)
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 dalam 3 hari
(0 Ulasan)
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 Lagi

$350 USD dalam 3 hari
(0 Ulasan)
0.0
$25 USD dalam 2 hari
(0 Ulasan)
0.0
ybhupendra

A proposal has not yet been provided

$91 USD dalam 2 hari
(0 Ulasan)
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 Lagi

$50 USD dalam 7 hari
(0 Ulasan)
0.0
salyhelmy18

have 4 years experience as oracle developer

$100 USD dalam 10 hari
(0 Ulasan)
0.0