Oracle / Database task

Đã Đóng

Mô tả

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]

Kỹ năng: Quản trị cơ sở dữ liệu, Phát triển cơ sở dữ liệu, Lập trình cơ sở dữ liệu, Oracle

Xem thêm: 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

Mã Dự Án: #13447926

32 freelancer đang chào giá trung bình $85 cho công việc này

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 trong 3 ngày
(110 Đánh Giá)
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 Thêm

$77 USD trong 1 ngày
(33 Đánh Giá)
4.9
vinaysinghh

A proposal has not yet been provided

$111 USD trong 5 ngày
(30 Đánh Giá)
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 Thêm

$80 USD trong 3 ngày
(5 Đánh Giá)
3.0
$305 USD trong 8 ngày
(9 Đánh Giá)
3.2
$35 USD trong 1 ngày
(7 Đánh Giá)
3.5
jagdishbhatt38

A proposal has not yet been provided

$133 USD trong 5 ngày
(6 Đánh Giá)
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 trong 4 ngày
(8 Đánh Giá)
3.1
$30 USD trong 1 ngày
(2 Đánh Giá)
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 Thêm

$100 USD trong 1 ngày
(2 Đánh Giá)
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 trong 20 ngày
(0 Đánh Giá)
0.0
consultkasyap

worked on database design projects in the past

$55 USD trong 2 ngày
(0 Đánh Giá)
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 trong 1 ngày
(0 Đánh Giá)
0.0
prakashparmar79

A proposal has not yet been provided

$25 USD trong 5 ngày
(0 Đánh Giá)
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 trong 3 ngày
(0 Đánh Giá)
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 Thêm

$350 USD trong 3 ngày
(0 Đánh Giá)
0.0
$25 USD trong 2 ngày
(0 Đánh Giá)
0.0
ybhupendra

A proposal has not yet been provided

$91 USD trong 2 ngày
(0 Đánh Giá)
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 Thêm

$50 USD trong 7 ngày
(0 Đánh Giá)
0.0
salyhelmy18

have 4 years experience as oracle developer

$100 USD trong 10 ngày
(0 Đánh Giá)
0.0