Design a database for storing information about medical doctors, their patients, and ilnesses:
1. Draw its E-R diagram.
2. Give a relational representation of the E-R diagram that allows for 2
functional preserving and lossless join decompositions. Describe its functional dependencies.
3. Give the two decompositions and prove that they are lossless join and
functional preserving.
4. Give the SQL DDLs for creating the three versions of the database.
5. Fill the first database with data (at least 100 columns in each table).
6. Give the SQL queries to copy the data from the first version into its 2 decompositions.
7. Propose in english 3 queries that require at least 2 table joins each and such that all
tables are involved in at least 2 queries.
8. Propose SQL implementations of the 3 queries on all three versions of the database.
9. Test the time in ns for exeuting the 3 queries on each database, by running each of them 1000 times.
Submit the databases populated with data, a file for each ddl ([login to view URL], [login to view URL], [login to view URL]), and a
report with a separate section for which of the above points.
Hello,
I am an expert with the database development and I have reviewed your requirements. I can do this project as per the specifications.
Thanks
Aanvik
Relevant Skills and Experience
Database , SQL
Proposed Milestones
$266 USD - Milestone
Greeting,
I have understood your create a databse task and can do it with your 100% satisfaction. Please ping me for more discussion.
Relevant Skills and Experience
I have more than 5 years of experience in Database Development, Database Programming, SQL, SQLite
Proposed Milestones
$150 USD - create a databse
Hi..having gone through your project details, I can help in completing your assignment. I have worked on several ERD projects, creating relationships, writing sql, ddl, queries etc. on several project
Relevant Skills and Experience
Technically well versed in handling such assignments and assure you of quick and efficient delivery. Waiting for your response to discuss in detail. Thanks.
Proposed Milestones
$138 USD - project fee
Hello, I saw your post and understood that you want to design Database for storing information about medical doctors, their patients, and illnesses:
Relevant Skills and Experience
I have 5 years of experienced in programming and as you want i can get this job done for you.
WORKED ON THE SIMILAR CONCEPT BEFORE AND DELIVER YOU THE JOB ON TIME LINE.
Proposed Milestones
$155 USD - PROPOSED MILESTONE PAYMENT
Hi there,
I have strong knowledge in relational database, plsql, dynamic query, pivot tables, normalization (1NF to BCNF), umls and more.
I have read the details and its an easy job for me.
Message me
Relevant Skills and Experience
Please have a look at my profile for similar database projects I completed and their reviews.
Proposed Milestones
$260 USD - Database Project
designing a database
Relevant Skills and Experience
I'm a BSc degree holder in computer science. I have worked on more than 1000 papers in report writing, research.I have read and understood your requirement and I know you will never regret, thank you.
Proposed Milestones
$155 USD - MM
i am oracle dba having more then 10 yrs of exp......
Relevant Skills and Experience
sql, rdbms
Proposed Milestones
$100 USD - project
Additional Services Offered
$1 USD - f
Hi there,
I read your all requirement . Let's come to chat I will deliver you want you. I have experience this field.
Thanks
Relevant Skills and Experience
Database Development, Database Programming, SQL
Proposed Milestones
$250 USD - Final delivery
Hello brother
lets discus your project.
Relevant Skills and Experience
Experienced database developer
MySQL, Oracle, SQL, Diagrams and report
Proposed Milestones
$200 USD - initial
Send me your project file or more details of database.
I am an experienced Database developer. I will do your project. Feel free to contact me for further discussion.
Regards,
Moeen
Relevant Skills and Experience
Database Systems
Database Design
Query
SQL Query
MySQL
MS SQL SERVER
Proposed Milestones
$155 USD - project
How much time do you have?
Hi there, you need a database expert?This is what I'm.I'll design your database in best quality and short time!
Hire me and enjoy the success.
Relevant Skills and Experience
I've developed so many databases including the one for an online store and for a Medical Store Management System. My expertise are in SQL and MySQL.
Proposed Milestones
$111 USD - I'll design ER-Diagram, then a Database tables and then I'll make the relations between tables.
Follow carefully the steps mentioned and provide a script with which you easily can reproduce all the steps and obtain the desired information.
Relevant Skills and Experience
- I architected and developed projects for tourism integrators who offer and sell their availability.
- Developed operational support systems (OSS) and network resources managers.
Proposed Milestones
$100 USD - E-R diagrams and SQL table creation
$50 USD - Data population and retrieval
$100 USD - Text report generation
Additional Services Offered
$100 USD - Application tests; Deployment and monitoring.
-What are your selection criteria?
-What will be the key points for this endeavor to be successful?
- You don't mean 100 columns but rows, right?