اسلاید پاورپوینت: اطلاعاتی (information) ، سازمان (organization) و برنامه (program)…

 

عناوین اصلی استخراج شده از این فایل پاورپوینت

عناوین اصلی استخراج شده از این فایل پاورپوینت

● Chapter 5
● Data
● DBMS ‘Discussion’ (۱)
● DBMS ‘Discussion’ (۲)
● DBMS ‘Discussion’ (۳)
● DBMS ‘Discussion’ (۴)
● Hierarchy of Data
● Terminology
● Data Entities, Attributes, and Keys
● Keys and Attributes
● The Traditional Approach
● Drawbacks
● Database Approach
● Advantages
● Disadvantages
● Data Modeling and
Database Models (1)
● Data Modeling and
Database Models (2)
● Example:
Entity Relationship (ER) Diagram for a Customer Ordering Database
● Hierarchical Database Model
● Network Data Model
● Relational Data Model
● Relational Database Terminology
● Linking Data Tables to Answer an Inquiry
● Building and Modifying a Relational Database
● Schemas and Subschemas
● Schema ‘Discussion’
● Data Definition Language
● Data Dictionary
● Data Dictionary Features
● Logical and Physical
Access Paths
● Manipulating Data
● Structured Query Language (SQL)
● SQL ‘Discussion’ (۱)
● SQL ‘Discussion’ (۲)
● SQL ‘Discussion’ (۳)
● Database Output
● Popular Database Management Systems for End Users
● Distributed Databases
● Data Warehouse
● Designing a Customer Data Warehouse
● Data Mining Applications
● On-Line Analytical
Processing (OLAP)
● Open Database
Connectivity (ODBC)
● Object-Relational Database Management Systems (ORDBMS)
● End of Chapter 5

نوع زبان : انگلیسی حجم : ۰٫۴۹ مگا بایت
نوع فایل : اسلاید پاورپوینت تعداد اسلایدها: ۶۱ صفحه
زمان استخراج مطلب : ۲۰۱۸/۱۱/۰۲ ۰۴:۵۶:۰۷ پسوند فایل : ppt

لینک دانلود رایگان لینک دانلود کمکی

 

در صورتی که محتوای فایل ارائه شده با عنوان مطلب سازگار نبود یا مطلب مذکور خلاف قوانین کشور بود لطفا در بخش دیدگاه (در پایین صفحه) به ما اطلاع دهید. جهت جستجوی پاورپوینت های بیشتر بر روی اینجا کلیک کنید.

این مطلب در تاریخ ۲۰۱۸/۱۱/۰۲ ۰۴:۵۶:۰۷ به صورت خودکار استخراج شده است. در صورت اعلام عدم رضایت تهیه کننده ی آن، طبق قوانین سایت از روی وب گاه حذف خواهد شد. همچنین این مطلب برگرفته از وب سایت زیر است و مسئولیت انتشار آن با منبع اصلی است.

http://www.cse.yorku.ca/~mack/1010/1010-Chapter5.ppt

بخشی از محتوای متن استخراج شده از این فایل ppt

بخشی از محتوای متن استخراج شده از این فایل ppt

itec ۱ ۱ information and organizations chapter ۵ organizing data and information itec ۱ ۱ information and organizations data data a necessity for almost any enterprise to carry out its business. consists of raw facts and when organized may be transformed into information database a collection of data organized to meet users’ needs database management system dbms a group of programs that manipulate the database and provide an interface between the database and the user of the database or other application programs itec ۱ ۱ information and organizations dbms ‘discussion’ ۱ a collection of programs that enables you to store modify and extract information from a database. there are many different types of dbmss ranging from small systems that run on personal computers to huge systems that run on mainframes. the following are examples of database applications computerized library systems automated teller machines flight reservation systems computerized parts inventory systems from a technical standpoint dbmss can differ widely. the terms itec ۱ ۱ information and organizations dbms ‘discussion’ ۲ relational network flat and hierarchical all refer to the way a dbms organizes information internally. the internal organization can affect how quickly and flexibly you can extract information. requests for information from a database are made in the form of a query which is a stylized question. for example the query select all where name smith and age ۳۵ requests all records in which the name field is smith and the age itec ۱ ۱ information and organizations dbms ‘discussion’ ۳ field is greater than ۳۵. the set of rules for constructing queries is known as a query language. different dbmss support different query languages although there is a semi standardized query language called sql structured query language . sophisticated languages for managing database systems are called fourth generation languages or ۴gls for short. the information from a database can be presented in a variety of formats. most dbmss include a report writer program that enables you to output data in the form of a report. many dbmss also include itec ۱ ۱ information and organizations dbms ‘discussion’ ۴ a graphics component that enables you to output information in the form of graphs and charts. itec ۱ ۱ information and organizations hierarchy of data schematic itec ۱ ۱ information and organizations hierarchy of data example database files records fields characters bytes personel file department file payroll file project database ۵ ۱ ۶۳۲۱ johns francine ۱ ۷ ۶۵ ۵۴۹ ۷۷ ۱ ۱ buckley bill ۲ ۱۷ ۷۹ ۹۸ ۴ ۱۳۷ fiske steven ۱ ۵ ۸۵ personnel file ۹۸ ۴ ۱۳۷ fiske steven ۱ ۵ ۸۵ ۵۹۸ record containing ssn last name first name date of hire fiske last name field ۱ ۱ letter ‘f’ in ascii itec ۱ ۱ information and organizations terminology database a collection of integrated and related files file a collection of related records record a collection of related fields field a group of characters character basic building block of information represented by a byte itec ۱ ۱ information and organizations data entities attributes and keys entity a generalized class of people places or things objects for which data are collected stored and maintained e.g. customer employee attribute a characteristic of an entity something the entity is identified by e.g. customer name employee name keys a field or set of fields in a record that is used to identify the record e.g a field or set of fields that uniquely identifies the record itec ۱ ۱ information and organizations keys and attributes key field attributes fields entities records employee last name first name hire date dept. ۵ ۱ ۶۳۲۱ johns francine ۱ ۷ ۶۵ ۲۵۷ ۵۴۹ ۷۷ ۱ ۱ buckley bill ۲ ۱۷ ۷۹ ۶۵ ۹۸ ۴ ۱۳۷ fiske steven ۱ ۵ ۸۵ ۵۹۸ itec ۱ ۱ information and organizations the traditional approach the traditional approach… separate files are created and stored for each application program schematic itec ۱ ۱ information and organizations payroll payroll programs reports data files application programs users invoicing invoicing programs reports inventory control inventory control programs reports management inquiries management inquiries programs reports itec ۱ ۱ information and organizations drawbacks data redundancy duplication of data in separate files lack of data integrity the degree to which the data in any one file is accurate program data dependence a situation in which program and data organized for one application are incompatible with programs and data organized differently for another application itec ۱ ۱ information and organizations database approach the database approach… a pool of related data is shared by multiple application programs rather than having separate data files each application uses a collection of data that is either joined or related in the database schematic itec ۱ ۱ information and organizations payroll data inventory data invoicing data other data database management system payroll program inventory program invoicing program other programs reports reports reports reports database interface applications programs users itec ۱ ۱ information and organizations advantages improved strategic use of corporate data reduced data redundancy improved data integrity easier modification and updating data and program independence better access to data and information standardization of data access a framework for program development better overall protection of the data shared data and information resources itec ۱ ۱ information and organizations disadvantages relatively high cost of purchasing and operating a dbms in a mainframe operating environment increased cost of specialized staff increased vulnerability itec ۱ ۱ information and organizations data modeling and database models ۱ planned data redundancy a way of organizing data in which the logical database design is altered so that certain data entities are combined summary totals are carried in the data records rather than calculated from elemental data some data attributes are repeated in more than one data entity to improve database performance itec ۱ ۱ information and organizations data modeling and database models ۲ data model a map or diagram of entities and their relationships enterprise data modeling data modeling done at the level of the entire organization entity relationship er diagrams a data model that uses basic graphical symbols to show the organization of and relationships between data itec ۱ ۱ information and organizations example entity relationship er diagram for a customer ordering database schematic itec ۱ ۱ information and organizations order customer product ۱ n one to many relationship last name colour identification number name first name identification number attributes entities ۱ n itec ۱ ۱ information and organizations hierarchical database model hierarchical database model a data model in which data are organized in a top down or inverted tree structure schematic itec ۱ ۱ information and organizations department c employee ۱ employee ۲ employee ۳ employee ۴ employee ۵ employee ۶ department b project ۱ department a itec ۱ ۱ information and organizations network data model network data model an expansion of the hierarchical database model with an owner member relationship in which a member may have many owners project ۱ project ۲ department a department b department c itec …

کلمات کلیدی پرکاربرد در این اسلاید پاورپوینت: اطلاعاتی (information), سازمان (organization), برنامه (program), نام (name), میدان (field), پرونده (file),

این فایل پاورپوینت شامل ۶۱  اسلاید و به زبان انگلیسی و حجم آن ۰٫۴۹ مگا بایت است. نوع قالب فایل ppt بوده که با این لینک قابل دانلود است. این مطلب برگرفته از سایت زیر است و مسئولیت انتشار آن با منبع اصلی می باشد که در تاریخ ۲۰۱۸/۱۱/۰۲ ۰۴:۵۶:۰۷ استخراج شده است.

http://www.cse.yorku.ca/~mack/1010/1010-Chapter5.ppt

  • جهت آموزش های پاورپوینت بر روی اینجا کلیک کنید.
  • جهت دانلود رایگان قالب های حرفه ای پاورپوینت بر روی اینجا کلیک کنید.

پاسخی بگذارید

نشانی ایمیل شما منتشر نخواهد شد. بخش‌های موردنیاز علامت‌گذاری شده‌اند *