‏why it is not possible to maintain a database with just physical structures i.e. datafiles, log...

‏why it is not possible to maintain a database with just physical structures i.e. datafiles, log files etc. Solution should emphasize on the need of having

tablespaces, segments, extents and data blocks and their usage by the Database Administrator in effective management of database؟

Expert Solution

The logical structure of the database is an important feature of the DBMS software. Because we need to organize the object in logical fashion otherwise retrieving the data or processing the data will become a very hectic task. Data is said to be facts and statistics stored or free-flowing over a network, which is generally, in its raw form, unprocessed or even processed. One of the major aims of a database is to supply users with an abstract view of data, hiding a certain element of how data is stored and if it is being stored with just physical structure i,e datafiles, logfiles then it would become difficult to retrieve the relevant and required data at a right time. A database management system is very crucial because it helps to manage data efficiently and allows users to perform multiple tasks with ease. A database management system stores organize and manage a large amount of information within a single software application. The use of this system increases the efficiency of business operations and thus helps in an overall reduction of costs. Data are being categorized and structured to fulfill the needs of the company or an organization. Multi layering of the database system is very important so that the storage of data is done systematically.

A database system normally contains a huge amount of data in addition to users’ data. In single-layered data, it is difficult to make any changes once the input is being registered but in the database, it can be changed over time so that it satisfies the requirements of the users.An extent is said to be a specific number of contiguous data blocks allocated for storing a specific kind of statistics. the smallest unit of data used by a database is called a data block. All these units help in systematic and efficient use of data.

keosha answered 4 months ago

A chemistry student five possible Lewis structures for the cyanate ion. Give a reason why structures...

A chemistry student five possible Lewis structures for the cyanate ion. Give a reason why structures (4) and (5) are wrong. (2) Calculate the formal charge of each individual atom and determine which structure is the preferred one. (11) Structure 1 Atom N C O Valence electrons Bonding electrons Nonbonding electrons Formal Charge Structure 2 Atom N C O Valence electrons Bonding electrons Nonbonding electrons Formal Charge Structure 3 Atom N C O Valence electrons Bonding electrons Nonbonding electrons Formal...

Database Design CIW State_Capitals Physical Database Create primary and secondary keys for the attached unfinished physical...

Database Design CIW State_Capitals Physical Database Create primary and secondary keys for the attached unfinished physical database design. CREATE DATABASE STATE_CAPITALS; GO USE STATE_CAPITALS; GO CREATE TABLE Country( Country_Code varchar(10) NOT NULL, Country_Name varchar(50) NOT NULL, Population int NOT NULL, Country_Size float NOT NULL ) GO CREATE TABLE Region( Country_Code varchar(10) NOT NULL, Region_Code varchar(10) NOT NULL, Region_Name varchar(50) NOT NULL ) GO CREATE TABLE State( Region_Code varchar(10) NOT NULL, State_Code char(2) NOT NULL, State_Name varchar(50) NOT NULL, Date_of_Statehood int...

True or False: Logical database design is the process of modifying the physical database design to...

True or False: Logical database design is the process of modifying the physical database design to improve performance. The two major logical database design techniques are conversion of E-R diagrams to relational tables and data normalization. Multivalued attributes are not permitted in unnormalized data. A many-to-many binary relationship in an E-R diagram requires the creation of a total of three tables in a relational database. A one-to-one unary relationship in an E-R diagram requires the creation of a total of...

Which of the below are possible reasons for why some IPOs are underpriced [i.e., the price...

Which of the below are possible reasons for why some IPOs are underpriced [i.e., the price rises a lot on the first day]? It is necessary to compensate investors for risks of buying the security, including both “market timing” by firms and the “winner’s curse” To minimize the underwriter fees paid by the issuer and maximize the amount of capital the firm is able to raise Because of a conflict of interest between underwriters and the issuer Only (a) and...

Q1: Explain the different database structures in database management system (DBMS) Q2: What are the roles...

Q1: Explain the different database structures in database management system (DBMS) Q2: What are the roles of OSI layers to transmit data from one computer to another computer?

Referring to specific anatomical structures, how is vision affected by the physical structures of the eye?...

Referring to specific anatomical structures, how is vision affected by the physical structures of the eye? a) Eyeballs of a newborn are shorter (front to back) than the eyes of an adult b) In some individuals, continued growth of eyeballs front to back exceeds the average rate c) In some individuals, continued growth of eyeballs front to back is slower than the average rate d) During aging, overall melanin production tends to decline

Create the actual database using SQL syntax. This is completed using a Database Application (i.e Microsoft...

Create the actual database using SQL syntax. This is completed using a Database Application (i.e Microsoft Access, Oracle, or MySQL) as indicated by your professor. After creating the database – populate it with some data (could be made up). SQL syntax and the DB application will be discussed and taught in class. This is the final deliverable of the group project. Assignment is due by the due date as indicated by your professor. *Make sure to submit the completed database...

Why is it not possible for all countries to follow a demand-focused (i.e. expansionary) growth strategy,...

Why is it not possible for all countries to follow a demand-focused (i.e. expansionary) growth strategy, given that the world can be viewed as a closed economy? - 15 marks

22. One possible explanation for why some bird’s migration and others maintain year-round residency in a...

22. One possible explanation for why some bird’s migration and others maintain year-round residency in a single location is intelligence. Specifically, birds with small brains, relative to their body size, are simply not smart enough to find food during the winter and must migrate to warmer climates where food is easily available (Sol, Lefebvre, & Rodriguez- Teijeiro, 2015). Birds with bigger brain on the other hand, are more creative and can find food even when the weather turns harsh. Following...

Why do banks want to maintain as little excess reserves as possible? Under what circumstances might...

Why do banks want to maintain as little excess reserves as possible? Under what circumstances might banks desire to hold excess reserves? (Hint: see Figure 14.3.) Follow up question: In recent years, the Fed has purchased toxic assets and bonds from banks and given them cash in exchange. The idea has been to boost lending and therefore economic activities and employment. This is called QE for quantitative Easing. However, banks have not been keen in issuing loans to individuals and...

Question