5) Name the data model that is only used to document a database design. 6) State...

5) Name the data model that is only used to document a database design.

6) State the most important characteristics regarding the output of any relational algebra operation.

7) Name the software system that permits the data in a distributed database to be transparent to others.

8) Use two words to distinguish a file based system and a database.

Solutions

Expert Solution

5) Name the data model that is only used to document a database design.

Answer:-

The data model that is only used to document a database design is Entity Relationship Model (ER Model).
A relational model is used for sorting data in the table with each relation.

6) State the most important characteristics regarding the output of any relational algebra operation.

Answer:-

The relational algebra operations is performed on a table of one or even more tables of relational.
Whatever the produced table is it will have the relational model properties.
It is said that it shall produce another table called as relational table.

7) Name the software system that permits the data in a distributed database to be transparent to others.

Answer:-

Distributed Database Management System .
It is the software that permits the data in distributed database to be transparent to others .
It is also know as distributed DBMS.

8) Use two words to distinguish a file based system and a database.

Answer:-

Data consistency-

File based system can not provide it but DBMS database can provide it easily using normalization.

Data access -

Database has you can say flexible access to data normally calles as Queries whereas file based system is allowed only some pre- determined access that is program which is compiled.

venereology answered 2 days ago

Next > < Previous

Related Solutions

Database Management Systems for Business Name the data model that is only used to document a...

Database Management Systems for Business Name the data model that is only used to document a database design. 6. State the most important characteristics regarding the output of any relational algebra operation. Name the software system that permits the data in a distributed database to be transparent to users. Use two words to distinguish a file based systems and a database. 9. Name the level to represent an organization view in the three-level ANSI-SPARK architecture. 10. Name the terminology of...

Database design is the process of producing a detailed data model of database. This data model...

Database design is the process of producing a detailed data model of database. This data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design in a data definition language, which can then be used to create a database. (Wikipedia). Using a diagram/chart software, elaborate a database design Requirements: Define your database objective Explain your database's type of table relationship Explain and design your database elements and datatypes (tables, fields, etc,)....

Data Modeling and Database Design (Database Concepts, Eighth Edition) The relational model is the most important...

Data Modeling and Database Design (Database Concepts, Eighth Edition) The relational model is the most important standard in database processing today. Why do you feel that this model has continued to be successful in the world of IT? What would happen if large corporations decided to reject this theory, and store their data using a non-relational model? Are there any success stories where this has happened?

Use Figure 7-5 to research a database service for an enterprise-level relational database and document

Use Figure 7-5 to research a database service for an enterprise-level relational database and document three new key terms based on how that particular vendor handles that particular service. (Examples: Data security by Oracle, Data integrity by MySQL, Backups by SQL Server).

Create a Database from blank (scratch) for a manager and name it. Create and design a...

Create a Database from blank (scratch) for a manager and name it. Create and design a table and name it. For each fields click and choose proper a data type such as short text and name the field. Make at least three fields. Enter your records. Make sure to add your name as a record. Similarly create two more tables. By design tool, make a relationship between each of two tables at a time and drag a primary key one...

Very carefully read the following data requirements for a prospective document translation database: i. Document translation...

Very carefully read the following data requirements for a prospective document translation database: i. Document translation initially relies on a source document. The source document is a text provided in the originally recorded, valid language (see below, and assume only one language for the original document), and has an associated author and publication date. Source document authors are not related to translators in any manner. ii. Translation of a document also relies on a translator, who is capable of translating...

Sometimes a data dictionary is called as ‘the database designer’s database’. State and explain your opinion...

Sometimes a data dictionary is called as ‘the database designer’s database’. State and explain your opinion regarding this term and support your position using real-life scenarios.

Design a C++ program An address book is a book or a database used for saving...

Design a C++ program An address book is a book or a database used for saving and storing contacts which may usually consists of a few standard fields (for example: first name, last name, company name, address, telephone number, e-mail address, fax number, mobile phone number). Design an online address book to keep track of the details of family members, close friends and certain business associates. Details which your designed address book will keep should be like names (first name,...

What process model is used to document the scope for an information system, and what is...

What process model is used to document the scope for an information system, and what is depicted in this process model?

The following data is to be used to construct a regression model: x 5 7 4...

The following data is to be used to construct a regression model: x 5 7 4 15 12 9 y 8 9 10 22 16 12 The value of SSE is ____________.

Subjects