\n

DATABASE APPLICATION PROJECT<\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
GENERAL GUIDELINES<\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
PURPOSE<\/span><\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
There are three main purposes of the database application project:<\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
1.             <\/span><\/span><\/strong>To analyze, design and implement a simple database project that applies to a specific business or personal data <\/span><\/strong><\/pre>\n
          management<\/span> need.<\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
2.             <\/span><\/span><\/strong>To become familiar with the features and use of an actual database management systems product.<\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
3.             <\/span><\/span><\/strong>To evaluate the product in terms of how successfully it is able to satisfy the major objectives of the database <\/span><\/strong><\/pre>\n
               approach<\/span>. These include: independence, integrity, security, recovery, concurrency, limiting redundancy, <\/span><\/strong><\/pre>\n
               performance, ease of use, and power of expression of its DDL\/DML.<\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
PROCEDURE<\/span><\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
Follow the steps given below:<\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
1.             <\/span><\/span><\/strong>Identify a reasonably simple but meaningful business or personal data management problem.<\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
2.             <\/span><\/span><\/strong>Analyze and design a database using E-R Diagrams, database normalization, and other techniques presented in the <\/span><\/strong><\/pre>\n
               course<\/span> that will help solve your problem.<\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
3.             <\/span><\/span><\/strong>Learn the basics of Microsoft Access and use Access to implement your database solution.<\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
4.             <\/span><\/span><\/strong>Implement your Project using Microsoft Access 2000 or later version.<\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
OUTCOMES<\/span><\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
Each student will be responsible for handing in the following:<\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
1.             <\/span><\/span><\/strong>A report describing the database management problem you have set out to solve, the approach you took to solve it, <\/span><\/strong><\/pre>\n
         and<\/span> your evaluation of Microsoft Access's capabilities.<\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
2.             <\/span><\/span><\/strong>Your<\/span><\/strong><\/span> E-R Model, sample output or listing showing inputs, and the results of your use of the project you developed.<\/span><\/strong><\/pre>\n
         Note that most reports run from 10-15 pages in length.<\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
Your database project should include the following:<\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
  a.  A<\/span> narrative of your database project, including its purpose<\/span><\/strong><\/pre>\n
       and<\/span> objectives, and how a database might well solve your<\/span><\/strong><\/pre>\n
       information<\/span> needs;<\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
  b.  The<\/span> ERD (either Chen Model or Crow\u2019s Foot Model)  conceptual <\/span><\/strong><\/pre>\n
       design<\/span> for that database; <\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
  c.  A<\/span> Descriptions of the tables (entities) and columns <\/span><\/strong><\/pre>\n
      (attributes<\/span>);   <\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
  d.  Listing<\/span> of the data;<\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
  e.  Sample<\/span> of queries and resulting reports;<\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
  f.  Summary<\/span> of what you learned and your reaction to the experience<\/span><\/strong><\/pre>\n
      of<\/span> creating you database application.<\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
 Note:  The possible applications are limitless, but it does NOT have to be very complex.  If you can tie it in with <\/span><\/strong><\/pre>\n
             something<\/span> that is related to your job, so much the better.  If not, find something that is of interest to you.<\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
DUE DATE<\/span><\/span><\/strong><\/pre>\n
 <\/span><\/strong><\/pre>\n
The Project Report is due at the end of the semester.  Please s<\/span><\/strong>ubmit your Project Report in electronic form to the Database <\/span><\/strong><\/pre>\n
Project Assignment In-Box during Week 12.<\/span><\/strong><\/span>  Do NOT submit your MS Access database itself; only your Project Report is <\/span><\/strong><\/pre>\n
needed<\/span><\/strong><\/span>.<\/span><\/strong><\/pre>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
DATABASE APPLICATION PROJECT     GENERAL GUIDELINES       PURPOSE   There are three main purposes of the database application project:   1.             To analyze, design and implement a simple database project that applies to a specific business or personal data           management need.   2.             To become familiar with the features and use of […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_joinchat":[]},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/68165"}],"collection":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/comments?post=68165"}],"version-history":[{"count":1,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/68165\/revisions"}],"predecessor-version":[{"id":69119,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/68165\/revisions\/69119"}],"wp:attachment":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/media?parent=68165"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/categories?post=68165"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/tags?post=68165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}