Infographic Template Galleries

Created with Fabric.js 1.4.5 1) Latek,R. (2004 May 12) , Efficiently managing and manipulating your data.Retrieved January 25, 2015.2) Gadot,J. (2013,August 19) , Fundamentals of database ppt ch01.Retrieved January 26,2015.3) Rouse,M. (n.d) , Health care provider database . Retrieved January 26,2015.4) Burke,A. (2009,April 15) , How databases are used in E-business. Retrieved January 26,2015.5) Davidson,L. (2007, March 26). Ten common database design mistakes, retrieved january 26,2015.6) -database solutions and downloads for microsoft access. (n.d).Retrieved January 26,2015. DATABASE INFO CORNER AND ARE GREAT TO LOOK AT WHAT IS A DATABASE ?? IMPORTANCE HOW TO OVERCOME ? - A collection of data- A set of data rules to manipulate data- A method to mold information into knowledge- A shared collection of logically related data designed to meet information needs of an organization ( Latek, R.) - Efficient manipulation of large data sets.- Integration of multiple data sources- Cross links/ references to offer resources.- Manage incredible variety of information easily.- Data sharing facility- Data Consistency (Latek,R) and ( Gadot.J) CHALLENGES/ISSUES THAT MAY FACE DURING DATABASE DESIGN AND DEVELOPMENT - Repetition of information - Provide erroneous info.- Fail to work properly- Database docummentation not up to date- Accumulate the load through complex design ,without changing pysical structure.- Not using SQL facilities to protect data integrity. ( Davidson,L.) - Eliminate redundant data ( storing the same data in more than one table ) .- Ensure data dependencies make sense.- Make sure that a table contains only data related to the primary key .- Ensuring each data field contains only one items of data.- Database documentation will have to change again and again . Corresponding to physical structure and depending changes- Significant redesign and coding possibly required.- The base rules of nullability , string length, assignment of foreign keys, should all be defined in the database. ( REAL WORLD EXAMPLEOF DATABASE E-Business Database ( Burke, A.)- Using oracle,Microsoft, to manage their databse transaction environment.- In addition, the function is for the customer service interactions , and capability of tying togather many business processes in single package.Health Care provider Database ( Rouse, M.) - Store information about each doctor working for them in many different states, and specific patients information also kept. - Doctors and nurses can browse information about their patients to write new prescriptions. REFERENCES
Create Your Free Infographic!