Oracle / Database task

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

[login to view URL]

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

Lihat lagi: 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

Tentang Majikan:
( 370 ulasan ) Mutrah, Oman

ID Projek: #13447926

29 pekerja bebas membida secara purata $88 untuk pekerjaan ini


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
(118 Ulasan)

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
(42 Ulasan)

A proposal has not yet been provided

$111 USD dalam 5 hari
(50 Ulasan)
$35 USD dalam sehari
(16 Ulasan)

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
(11 Ulasan)

A proposal has not yet been provided

$133 USD dalam 5 hari
(7 Ulasan)

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
(8 Ulasan)

I'm a BSc degree holder in computer science and a master degree holder in strategic management. I have worked on more than 1000 papers in report writing, Assignment delivery, content writing, Business plans, dissertati Lagi

$25 USD dalam sehari
(9 Ulasan)
$305 USD dalam 8 hari
(12 Ulasan)
$30 USD dalam sehari
(3 Ulasan)

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
(1 Ulasan)

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)

A proposal has not yet been provided

$25 USD dalam 5 hari
(0 Ulasan)

A proposal has not yet been provided

$91 USD dalam 2 hari
(0 Ulasan)

have 4 years experience as oracle developer

$100 USD dalam 10 hari
(0 Ulasan)

worked on database design projects in the past

$55 USD dalam 2 hari
(0 Ulasan)

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)

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)

A proposal has not yet been provided

$55 USD dalam 10 hari
(0 Ulasan)
$166 USD dalam 10 hari
(0 Ulasan)