ECET 450 iLab6 Simple Medicine Database - 88376

Solution Posted by


Rating : (19)A+
Solution Detail
Price: $40.00
  • From: Computer Science, Algebra
  • Posted on: Sat 14 Feb, 2015
  • Request id: None
  • Purchased: 1 time(s)
  • Average Rating: No rating
Request Description
ECET 450 iLab6 Simple Medicine Database ECET 450: Laboratory 6 Simple Medicine Database This laboratory exercise involves a complete development of a relational database. You are to do the following: 1. Use Visio to create the appropriate diagrams. 2. Create a script named mdbXXX.sql (where XXX are your initials) that • Create the tables in 3NF needed to implement your DB schema. • Your tables must include primary and foreign key constraints. • Populate the database. • Create the report that includes all three patients. • Each student will be required to add an individual query. See your instructor for the specifications of your query. Patient Doctor Room Admitted Required Medication -------------------------------------------------------------------- ----------------------------------- 1001 Fred Payne 101 MARCH 31, 2004 2 Prozac 3 grams annually 6 Aspirin 1 gram daily 9 Valium 2 grams weekly 3. Deliverables include copies of the following files: • The Visio ERD file (mdbXXX.vcd) • The ORACLE script file (mdbXXX.sql) • The spool output file (mdbXXX.lst) Development Suggestions for the mdbXXX.sql File 1. Ensure that the entire script is working before you “un-comment” the spool statements. 2. Develop your script one step at a time. 3. Include your personal and program information in the script file comment. 4. Suggested steps in developing the SQL script file: • SET system parameters • DROP TABLE firstTable • CREATE TABLE firstTable • DESC firstTable • INSERT VALUES INTO firstTable • CREATE VIEW if needed • SELECT * FROM firstTable • Repeat for secondTable • Repeat for rest of tables • JOIN all of the tables to produce the desired Report • -- SPOOL OFF Table of Data Patient Name Patient Number Medication Name No. of Tablets Dosage/ Tablet Frequency Admitted Rm. Dr. Fred 1001 Prozac 2 3 grams annually 30-MAR-07 101 Payne Fred 1001 Aspirin 6 1 gram daily 30-MAR-07 101 Payne Fred 1001 Valium 9 2 grams weekly 30-MAR-07 101 Payne Sam 1005 Spam 1 3 grams 2 x daily 02-APR-07 150 Acres Sam 1005 Prozac 2 6 grams daily 02-APR-07 150 Acres Betty 1010 Spam 1 4 grams daily 11-MAY-07 222 Itchi Betty 1010 Aspirin 6 3 grams daily 11-MAY-07 222 Itchi Betty 1010 Valium 9 1 gram weekly 11-MAY-07 222 Itchi Betty 1010 Sugar Water 11 1 gram monthly 11-MAY-07 222 Itchi
Solution Description
</div> <div class="sl_file_attachments"> <div class="dtel_hdng">Attachments</div> <figure title=""> <img src="" alt="" /> <figcaption> <span></span> </figcaption> </figure> </div> </div> </div> </div> <section id="footerlist"> <div class="container wow fadeInDown move"> <div class="row"> <div class="col-sm-4 col-md-2"> <div class="foo-widget"> <span><img id ="business-sprite" src="" alt="Business" width="23" height="42"/></span> <h3>Business</h3> <ul> <li > <a href="/subjects/accounting-homework-help/"> Accounting </a> </li> <li > <a href="/subjects/administration-homework-help/"> Administration </a> </li> <li > <a href="/subjects/business-homework-help/"> Business</a> </li> <li > <a href="/subjects/business-statistics-homework-help/"> Business Statistics</a> </li> <li > <a href="/subjects/cost-accounting-homework-help/"> Cost Accounting</a> </li> <li > <a href="/subjects/finance-homework-help/"> Finance</a> </li> <li > <a href="/subjects/global-management-homework-help/"> Global Management</a> </li> <li > <a href="/subjects/human-resource-management-homework-help/"> Human Resource Management</a> </li> </ul> </div> </div><!--/.col-md-2--> <div class="col-sm-4 col-md-2"> <div class="foo-widget"> <span><img id ="computer-science-sprite" src="" alt="Computer Science" width="62" height="41"/></span> <h3>Computer Science</h3> <ul> <li > <a href="/subjects/c++-homework-help/"> C++ </a> </li> <li > <a href="/subjects/html-homework-help"> HTML </a> </li> <li > <a href="/subjects/java-homework-help/"> Java</a> </li> <li > <a href="/subjects/object-oriented-programming-homework-help/"> Object Oriented Programming</a> </li> <li > <a href="/subjects/php-homework-help/"> PHP</a> </li> <li > <a href="/subjects/programming-homework-help"> Programming</a> </li> <li > <a href="/subjects/website-development-homework-help"> Website Development</a></li> </ul> </div> </div><!--/.col-md-2--> <div class="col-sm-4 col-md-2"> <div class="foo-widget"> <span><img id ="mathematicsg-sprite" src="" alt="Mathematics" width="44" height="44"/></span> <h3>Mathematics</h3> <ul> <li > <a href="/subjects/applied-mathematics-homework-help/"> Applied Mathematics </a> </li> <li > <a href="/subjects/calculus-homework-help/"> Calculus </a> </li> <li > <a href="/subjects/geometry-homework-help/"> Geometry</a> </li> <li > <a href="/subjects/pure-mathematics-homework-help/"> Pure Mathematics</a> </li> <li > <a href="/subjects/statistics-and-probability-homework-help/"> Statistics and Probability </a> </li> <li > <a href="/subjects/systems-science-homework-help/"> Systems science</a> </li> </ul> </div> </div><!--/.col-md-2--> <div class="col-sm-4 col-md-2"> <div class="foo-widget"> <span><img id ="applied-science-sprite" src="" alt="Applied Science" width="58" height="43"/></span> <h3>Applied Science</h3> <ul> <li > <a href="/subjects/agriculture-homework-help/"> Agriculture </a> </li> <li > <a href="/subjects/architecture-homework-help/"> Architecture</a> </li> <li > <a href="/subjects/civil-engineering-homework-help/"> Civil Engineering </a> </li> <li > <a href="/subjects/communication-homework-help/"> Communication</a> </li> <li > <a href="/subjects/education-homework-help/"> Education</a> </li> <li > <a href="/subjects/electrical-engineering-homework-help/"> Electrical Engineering</a> </li> <li > <a href="/subjects/engineering-homework-help/"> Engineering</a> </li> <li > <a href="/subjects/environmental-studies-homework-help/"> Environmental studies</a> </li> </ul> </div> </div><!--/.col-md-2--> <div class="col-sm-4 col-md-2"> <div class="foo-widget"> <span><img id="humanitiestutor-sprite" src="" alt="Humanities Tutor" width="64" height="42"/></span> <h3>Humanities Tutor</h3> <ul> <li > <a href="/subjects/arts-homework-help/"> Arts </a> </li> <li > <a href="/subjects/history-homework-help/"> History </a> </li> <li > <a href="/subjects/linguistics-homework-help/"> Linguistics</a> </li> <li > <a href="/subjects/literature-homework-help/"> Literature</a> </li> <li > <a href="/subjects/philosophy-homework-help/"> Philosophy</a> </li> <li > <a href="/subjects/religious-studies-homework-help/"> Religious Studies</a> </li> </ul> </div> </div><!--/.col-md-2--> <div class="col-sm-4 col-md-2"> <div class="foo-widget"> <span><img id="natural-sprite" src="" alt="Natural Sciences" width="45" height="45"/></span> <h3>Natural Sciences</h3> <ul> <li > <a href="/subjects/biology-homework-help/"> Biology </a> </li> <li > <a href="/subjects/chemistry-homework-help/"> Chemistry</a> </li> <li > <a href="/subjects/earth-science-homework-help/"> Earth Sciences</a> </li> <li > <a href="/subjects/physics-homework-help/"> Physics</a> </li> <li > <a href="/subjects/space-sciences-homework-help/"> Space Sciences</a> </li> <li > <a href="/subjects/english-homework-help/"> English</a> </li> <li > <a href="/subjects/french-homework-help/"> French </a> </li> <li > <a href="/subjects/german-homework-help/"> German</a> </li> </ul> </div> </div><!--/.col-md-2--> </div> </div> </section><!--/#bottom--> <footer id="footer"> <div class="container wow fadeInDown"> <nav class="footer_nav"> <ul> <li> <a href="/login/"> Login </a> </li> <li><a href="">Contact Us</a></li><li><a href="">FAQ</a></li><li><a href="">Code of Conduct</a></li><li><a href="">Terms of Use</a></li><li><a href="">Privacy Policy</a></li><li><a href="">Affiliates</a></li><li><a href="">Fees</a></li><li><a href="">About</a></li> </ul> </nav> <div class="row"> <p>Copyright © 2015 Tutor Homework Help Online, Tutoring Online - StudentLance, Inc. All rights reserved.</p> <p> </p> </div> </div> </footer> <!--wrapper end--><script src=""></script> <script src=""></script> <script src="" type="text/javascript"></script><script> (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) })(window,document,'script','//','ga'); ga('create', 'UA-32575082-1', 'auto'); ga('send', 'pageview'); </script><script src="" type="text/javascript"></script><script src="" type="text/javascript"></script> <script type="text/javascript"> var $ = jQuery; var frm = $("form#login-form"); frm.submit(function (ev) { var data = frm.serialize(); $("#login-check-data").html('<div class="jax-img-hldr"><img src="" alt="" /></div>'); $.ajax({ type: "POST", url: "", data: data, success: function(resp) { $("#login-check-data").html(resp); } }); ev.preventDefault(); }); </script></body></html>