Lukket

Design and implementation of an object-relational database for railway company

Design and implementation of an object-relational database for railway company

Working with your domain description

You are given a domain description of 300-350 words. It contains the main entity sets (or object types) that must be stored as well as main functions that the system must do. You only must create the database, not the functionality – but must have a plan for object methods.

(Domain description will be provided in the attachments).

Please note that the domain description is not intended to be precise user requirements – instead consider it as a general description of the database to which you can add freely, create formulas for vague parts etc. You do not need to add much more content, however, you must implement everything that refers to the database in the text – that is the minimal requirement.

The project will be evaluated based on the appropriateness of the constructs used and their complexity – you have to add to the domain to get future and further hires.

Please note that the works that will not contain object types and will do simple relational design and implementation, will not be accepted!

The purpose of the vagueness of the domain description is twofold: (1) you may adapt the complexity of the domain according to your finance goals (if you want to get hired again for bigger, more complex and better paid projects), and (2) to prevent the situations when the work has been copied from internet. With these domain description, it is almost impossible to create two identical works unless it has been copied from somewhere else on the internet.

Submissions

The deadline for submissions is October 30.

You will have to submit 2 things:

• report (with a reference to where the system is implemented and link to demonstration video); • commented *.sql file.

Report

You must submit a report in *.doc or *.docx format (*.pdf also may be added but only if you are working in other document editor than MS Word) that contains:

0. Your name and surname as well as the title of the laboratory work

1. The conceptual and logical designs in form of class diagram and entity-relationship diagram

2. The reference to Oracle server profile where the system implemented ( [login to view URL]:1000 ).

3. The link to the video demonstration (either as a private video on, e.g., YouTube or via some file sharing service). The video demonstration (3-5 minutes) can be a recorded group call, e.g., in Zoom, where you show your created structures and explain more interesting parts of the design.

4. Conclusions (this is extremely important part) that must include:

• explanations and discussion on more interesting design/implementation details (the ones that created a discussions amongst yourselves;

• if it was a group work - how did you split the work? What was productive, what was not?

Commented *.sql file

A code with your comment for each query, with more complex/interesting parts pointed out.

The tasks in the practical work

1. Develop conceptual and logical designs in form of class diagram and entity-relationship diagram.

(Please see Attachment1)

2. Definition of object types for objects which are included in the tables, including object attributes and methods.

(Please see Attachment1)

3. Definition of REF type attributes and subtypes to create links among objects.

(Please see Attachment1)

4. Creation of data storage structures.

(Please see Attachment1)

5. Data input with INSERT command and optionally: with SQL*Loader

(Please see Attachment1)

6. Queries with the Value(), Table(), DEREF() functions to demonstrate how information can be obtained

(Please see Attachment1)

7. Preparing the submission:

(Please see Attachment1)

Domain: (Please see Attachment1)

Evner: SQL, Database Management, Oracle Database, Databaseudvikling, Database Administration

Se mere: basically company working web design development phpmysqlaspnet etc, database design implementation mysql, object relational database oracle, relational database design case study, database design implementation, database design implementation project, assumptions database design implementation, database design implementation rails, design database travel company access, relational database design, relational database design and implementation pdf, design and develop relational database, relational database design and implementation 4th edition free, relational database design and implementation 4th edition pdf download, object-relational database postgresql, object-relational database tutorial, object-relational database vs relational database, object-relational database examples, object relational database tutorialspoint

Om arbejdsgiveren:
( 0 bedømmelser ) Riga, Latvia

Projekt ID: #31866860

8 freelancere byder i gennemsnit €186 timen for dette job

fastlabindia

Greetings!. I checked your Database Design requirements. Your work is one of the tasks that can be done very perfectly by us. I am good in MySQL , MS ACCESS, MS SQL, Oracle , No SQL and other DBMS software, Queries, Re Flere

€30 EUR in 2 dage
(12 bedømmelser)
4.3
rexzetsolutions

Yes, i can make Design and implementation of an object-relational database for railway company. Message me i am ready to start work form right now.

€300 EUR in 3 dage
(11 bedømmelser)
4.2
(1 bedømmelse)
3.2
hussainmuzammal4

4. Creation of data storage structures. (Please see Attachment1) 5. Data input with INSERT command and optionally: with SQL*Loader (Please see Attachment1) 6. Queries with the Value(), Table(), DEREF() functions to dem Flere

€200 EUR in 7 dage
(2 bedømmelser)
3.3
hsh564cf84accd96

We will do your Database work I am writing this proposal in order to work for you in Software and Web Development. We are highly trained professional developers seeking to freelance and earn online. Having a flair in Flere

€200 EUR in 7 dage
(4 bedømmelser)
2.0
Muzammil460

Hi, I can help you out. I have been working with databases, database designs, SQL, PLSQL for the last 13 years and very easygoing and proficient with these. It would be my pleasure to work with you, if you are interest Flere

€200 EUR in 3 dage
(1 bedømmelse)
0.4
hamzashabbir1994

I am working as a database administrator in the IT industry for 5 years, and i am OCP, OCE,OCS certified in oracle database. [login to view URL] In this link you can check my certificates. Flere

€200 EUR in 7 dage
(0 bedømmelser)
0.0
santoshinpccs

Hi We are software development and IT solution provider registered firm with gov of India, having skilled people team of software developers, testers, functional and technical consultants and solution architects having Flere

€199 EUR in 15 dage
(0 bedømmelser)
0.0