Soru arşivi yükleniyor…
Sorular yükleniyor…
Sınav ve konu sorularıyla çalış. Cevabını kontrol et, zorlandığın soruları kaydet ve yeniden çöz.
288 sorunun metninde arama yapabilirsin.
Diğer 3 görselli soruları kendi sayfalarında çözebilirsin.
Kendi cevabını düşün, sonra yayımlanmış cevapla karşılaştır. Değerlendirmeyi sen yaparsın.
İlerleme yükleniyor…
The hierarchical relationship between data, information, knowledge, and wisdom (DIKW) can be represented in a pyramid, in which data are placed at the bottom whereas wisdom is placed at the top. As we go from bottom to top of the DIKW pyramid, magnitude decreases while understanding increases. There is plenty of raw data, but wisdom is limited. Thus, wisdom is the pinnacle of the pyramid.
Cevabın yayımlanmış cevapla uyuştu mu?
Data management is the development and execution of architectures, policies, practices and procedures in order to manage the information lifecycle needs of an enterprise in an effective manner.
Cevabın yayımlanmış cevapla uyuştu mu?
In information systems, data resources must be organized and structured in a logical way so that data can be processed, accessed, and queried easily and quickly. A collection of related data is stored into what is called database. A Database Management System (DBMS) is a collection software packages that is used for creating and maintaining a database.
Cevabın yayımlanmış cevapla uyuştu mu?
The DBMS is a software that facilitates the following processes: • Defining a database (determining the data types, structures and constraints) • Constructing the database (storing the data on some storage device) • Manipulating the database (querying, updating the database and generating reports) The database and DBMS software together are referred to as a database system.
Cevabın yayımlanmış cevapla uyuştu mu?
The advantages of using a DBMS in information system are: • Controlling redundancy • Restricting unauthorized access • Providing persistent storage for program objects and data structures • Permitting inferencing and actions using rules • Providing multiple user interfaces • Representing complex relationships among data • Enforcing integrity constraints • Providing backup and recovery
Cevabın yayımlanmış cevapla uyuştu mu?
The relational database model is the most widely used database structure. In the relational model, all data are stored in the form simple two-dimensional tables (p:48, Figure 2.7). In this database, “Departments Table” holds records of departments represented with four fields. Here, department number is the primary key. All the rows (records) must have a unique department name. Each row of “Projects Table” represents a project. The columns in the tables are fields. “Department Number” column exists in both of the Department table and the Projects tables. With the aim of this column, the two tables can be joined together. That is, “Department Number” field, which is a primary key in the Department Table, is called foreign key in Projects table. A foreign key is used to link two tables.
Cevabın yayımlanmış cevapla uyuştu mu?
A primary key is a special relational database table column (or combination of columns) designated to uniquely identify all table records. A primary key cannot be null and must be unique for each row of data.
Cevabın yayımlanmış cevapla uyuştu mu?
A foreign key is a field (or collection of fields) in one table that refers to the primary key in another table.
Cevabın yayımlanmış cevapla uyuştu mu?
The most popular relational database management systems are MySQL, Oracle Database, Microsoft SQL Server, Microsoft Access, Sybase, IBM Informix, PostgreSQL, and IBM Db2.
Cevabın yayımlanmış cevapla uyuştu mu?
The steps of the database design and data planning are summarized as can be seen below (p:49, Figure 2.8): 1. Data Planning: Develops a model of business processes. Enterprise model of business processes with documentation 2. Requirements Specification: Define information needs of end users in a business process. Description of users’ needs may be represented in natural language or using the tools of a particular design methodology. 3. Conceptual Design: Expresses all information requirements in the form of a high-level model. Conceptual Data Models often expressed as entity relationship models 4. Logical Design: Translates the conceptual models into the data model of a DBMS. Logical Data Models e.g., relational, network, hierarchical, multidimensional, or object-oriented models 5. Physical Design: Determines the data storage structures and access methods Physical Data Models Storage representations and access methods
Cevabın yayımlanmış cevapla uyuştu mu?
SQL is a standard language for storing, manipulating and retrieving data in databases. SQL is an American National Standards Institute (ANSI) standard (p:50, Table 2.5).
Cevabın yayımlanmış cevapla uyuştu mu?
NoSQL databases are the new alternatives to the relational databases for big data and real-time Web applications. Such databases have become popular by the needs of Web 2.0 companies such as Facebook, Google, and Amazon. Most of the modern applications require to scale horizontally, which is a problem for relational databases. Unlike the relational databases, NoSQL databases are designed to cope with the scale and agility challenges. NoSQL databases are useful when the data at hand exceed capacity of a single server. When this happens, data should be split into smaller pieces in a way that each piece can fit in to a single server. This is called sharding. NoSQL databases usually support auto-sharding; thus, they are natively able to handle load by spreading data among multiple servers. This ability makes NoSQL databases a natural fit for the cloud computing environments such as Amazon Web Services. The data model of NoSQL databases addresses several shortcomings of the relational databases.
Cevabın yayımlanmış cevapla uyuştu mu?
NoSQL database types are: Document databases, key-value stores, graph databases, and column-oriented stores. The most popular NoSQL databases are MongoDB, Cassandra, HBase, and Neo4j.
Cevabın yayımlanmış cevapla uyuştu mu?
The main benefit of NoSQL compared to relational databases is that NoSQL databases are more scalable and provide superior performance for certain operations.
Cevabın yayımlanmış cevapla uyuştu mu?
A data warehouse is a special type of relational database that is specifically designed and optimized for query and analysis. It may contain not only the historical data derived from transaction data, but also data from the other sources. Thus, data from several external or internal sources are consolidated by organizations.
Cevabın yayımlanmış cevapla uyuştu mu?
A data warehouse environment includes following the additional components compared to a relational database: • extraction, transportation, transformation, and loading (ETL) solution • an online analytical processing (OLAP) engine • client analysis tools • other applications that manage the process of gathering data and delivering it to business users.
Cevabın yayımlanmış cevapla uyuştu mu?
Data mining techniques can be used to deeply analyze the data stored in a data warehouse. Data mining is the processes of discovering patterns in a large volume of data involving methods of machine learning, statistics, and database systems. Data mining, sometimes entitled “knowledge discovery” in the context of databases, plays a critical role in the business or science world.
Cevabın yayımlanmış cevapla uyuştu mu?
A computer network is a system that enables computing devices to exchange data among themselves. With the help of computer networks, the users can exchange files, communicate with each other via e-mails, share hardware devices such as printers and faxes, and store data centrally.
Cevabın yayımlanmış cevapla uyuştu mu?
The primary hardware components are: • Network Interface Controllers (NIC) • Repeaters • Hubs • Bridges • Switches • Routers • Modems • Firewalls
Cevabın yayımlanmış cevapla uyuştu mu?
NIC is an interface between the computer and physical network connection in order to transmit data through the cable, address data with an identifier, control data flow, and connect to another computer (p:51, Figure 2.9).
Cevabın yayımlanmış cevapla uyuştu mu?
A repeater is a device that receive and retransmit the signal in order to protect the signal strength required to reach further away on the network.
Cevabın yayımlanmış cevapla uyuştu mu?
A hub is a device that transmits the data to the all connected computers without checking the destination address.
Cevabın yayımlanmış cevapla uyuştu mu?
A bridge is a device including software that connects two networks which uses the same protocol.
Cevabın yayımlanmış cevapla uyuştu mu?
A switch connects computers in a network like hubs but unlike hubs, switches learn destination address after the first communication and do not disturb irrelevant computers with message traffic.
Cevabın yayımlanmış cevapla uyuştu mu?
A router is a hardware that receives, analyzes and forwards the data to the another network. A router is programmable and it can divide a network into various subnets.
Cevabın yayımlanmış cevapla uyuştu mu?