Find Jobs
Hire Freelancers

Draw an (ER) diagram & Draw a data modle

$30-50 USD

Cancelled
Posted about 12 years ago

$30-50 USD

Paid on delivery
TASK 1 : Draw an Entity-Relationship (ER) diagram for a General Hospital’s database using the following information. 1. The General Hospital consists of a number of specialized WARDS (such as Maternity, Pediatrics, Oncology, etc). Each ward has a name, code and hosts a number of patients. 2. On admission, the personal details of every PATIENT are recorded. These include ID, name, address, gender, birth date and illness. We also need to store the information of the tests undertaken by a patient and the results of a prescribed treatment. A number of tests may be conducted for each patient. Each patient is assigned to one leading consultant but may be examined by another doctor, if required. 3. Each patient also has a ATTENDANT. This person is a family member or friend who looks after the patient and takes responsibility for them. 4. DOCTORS have their own IDs and a specialization in some branch of medicine and there are three types of doctors – consultants, specialists and interns. Each intern is supervised by a specialist doctor. One doctor can act as a consultant for a several patients. Their patients can be admitted in a number of wards. Clearly show primary key attributes. ------------------------------------------------- TASK 2 1. Draw a data model - having at least four attributes - of an entity of your choice. 2. Using SQL in Oracle 10g, a. Create a table for this entity and insert at least four rows of data. b. Conduct Project and Restrict in a single query. c. List rows in some given order. d. Modify a row based on a given condition. For each SQL task, you must show both the query and the output.
Project ID: 1583075

About the project

6 proposals
Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
6 freelancers are bidding on average $60 USD for this job
User Avatar
Pls check PMB.
$50 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I have done such job as a part of database course...i can do it efficiently...thanks
$40 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Fayrooz, I can help you with this. Have done some system design, including DB and process design. Please see my PM for my qualification. Looking forward to work with you.
$40 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
This is a simple project for me. You can have a look on the attachment.
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am quite interested about your project. Basically I have a group of innovative web and database designers and developers. We all are freelancers. Recently we did some excellent jobs. I have put some of them in my portfolio. I have skilled freelancers in the following area. Website design and development : 1. php 2. Joomla 3. WordPress 4. FrontPage 5. Dreamweaver 6. Flash Database design and development : 1. MySQL 2. ORACLE 3. MS Access 4. FoxPro For E-commerce : 1. Zen Cart 2. Virtue Mart 3. Magento Others : 1. AutoCAD 2D & 3D 2. 3D Studio Max 3. Photoshop 4. Illustrator Microsoft Office 1. MS Word (forms, get data from Excel ....) 2. MS Excel (any complicated equations, logic ....) 3. PowerPoint (samples can be shown upon request) 4. FrontPage (create static websites) I will be able to deliver this job in 20 days. Hoping to be working with you soon. Regards. Alam
$150 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi Hiring manager, I am writing to express my keen interest in joining your team My core competencies include: 1> BO XI R3 admin,Universe and WEBI report design 2> Data Modelling 3> Oracle PL/SQL 4> Actuate Reports 5> Oracle data Integrator 6> Testing Professionally I am looking for an opportunity that will help me utilize my skills in the above areas. I have over 6 years of experience in Information Technology Industry with 6 plus years of expertise in developing Business Intelligence and Data Warehouse applications. Strong understanding of Data warehouse concepts such as Star Schema, Snowflake Schema, OLTP, OLAP and Multi-Dimensional Models for query and analysis.I am an OCA and Actuate Certified with proven track record. Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating and production supporting on various platforms like UNIX, Windows NT/2000/XP/98.I competence includes: o Extensive experience working with End Users and Business System Analysts in understanding their requirements,assisting in providing technical solutions and implementing them. o Superior communication, presentation, analytical and problem solving skill. Worked well with all levels of business. o Good Knowledge of Dimensional Modeling and Data Warehousing concepts. o Profound experience in Requirement Gathering, Analysis and Design (Functional as well as Technical Specifications o Experience in creating Repositories, Folders, Groups, Users, assigning privileges to users and maintaining the Repository. o Technical hands-on expertise using OLAP tool Business Objects XIR2,XIR3(Reports, Designer, Web Intelligence, Info view , and Supervisor),Actuate o Expert in tuning the performance of SQL queries and ETL process. o Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable. o Expertise in Universe designing, developing and generating complex, Adhoc, dashboard Reports, Business views, List of values along with User Acceptance Test and data accuracy Test. o Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries. o Well experienced in writing Complex queries, stored procedures, functions, cursors and packages using PL/SQL Programming. o Design, development and coding with ORACLE 11g/10g/9i, Sybase,DB2. Strong work experience in Oracle Database (11g/10g/9i). SQL, PL/SQL, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links o Extensively worked Oracle supplied Packages, Stored Procedures, Triggers and Functions. I am open for an interview to discuss the ways in which I could assist you in accomplishing your goals. I look forward to hearing from you and a long term successful business engagement. Best Regards, Sudarshana
$50 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SAUDI ARABIA
Jeddah, Saudi Arabia
0.0
0
Member since Oct 15, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.