0
The logical constists of the name of the table, the attributes it contains, their types, the constraints on the attributes, if any.
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
What will represent logical storage of data in database?
view
Difference between logical database and physical database?
The logical database is how the data is percieved in the tables, the way the data is actually stored on the storage medium is the physical view of the database.
What is a logical database?
A logical database is the structure of data. It is the different pieces of information and the relationships between them.
What do you mean by logical schema in database?
tablespace,segment,extent,oracle blocks.. are the logical schema of a database
Show the difference bw 3-levels of data abstraction in DBMS?
The three levels of data abstraction in a DBMS are physical, logical, and view. Physical level: Describes how data is stored in the database, including details like data storage and access paths. Logical level: Focuses on the structure of the data in the database, including schemas, tables, and relationships. View level: Represents how users view the data, providing a customized and simplified representation of the data to different user groups.
What is a logical database designer?
* Logical database design: * ensuring, via normalisation procedures and the definition of integrity rules, that the stored database will be non-redundant and properly connected; * Physical database design: * specifying how database records are stored, accessed and related to ensure adequate performance. What is logical database designerThe major role of logical database design is to transform the combined, reconciled data specifications into basic or atomic elements following the well established rules for well structures data specifications. With a complete logical database design in place an analyst begins to specify the logic of the particular computer programs and queries needed to maintain and report the database content. The person who maintain or responsible to perform the above task is known as Logical Database designer.
What is data view?
Is a logical description of some portion of database that is required by user to perform some task.
What is schema instance?
In DBMS,Schema is the overall Design of the Database.Instance is the information stored in the Database at a particular moment.In programming,you declare a variable which corresponds to "Schema".But its values changes as and when required which corresponds to "Instance". Google about levels of Database Abstraction. Physical Schema describes database design at physical level while a logical schema describes the database design at the logical level.A database may also have several schemas at the view level, sometimes called subschemas, that describe different views of the database.
What is Schema and instances?
In DBMS,Schema is the overall Design of the Database.Instance is the information stored in the Database at a particular moment.In programming,you declare a variable which corresponds to "Schema".But its values changes as and when required which corresponds to "Instance". Google about levels of Database Abstraction. Physical Schema describes database design at physical level while a logical schema describes the database design at the logical level.A database may also have several schemas at the view level, sometimes called subschemas, that describe different views of the database.
What is the primary deliverable from logical database design?
normalized relations
Could you explain the purpose of logical database design?
Logical database design is the process of designing the database at a conceptual level as opposed to a physical level. There are many advantages of conceptual database design, such as the ability to design the database without having to commit to a particular database management system, to produce a document that is readable and understandable to everyone in the company (not just the database person) and to produce an overall design document that can be saved as a part of the documentation of the database for future enhancement, maintenance and support work. Logical database design produces documents for use in the same way that architects produce blueprints for building purposes.
What is the explanation for the components of database systems?
A Database consists of the following components.Schema - A Schema is a logical grouping of a set of database tablesTable - A table is a logical sub unit of information that is split up into rows and columns - much like the MS XL spreadsheetAll the data that is stored in a database is organized into tables and schemas.Apart from this, a database can have:ViewsFunctionsStored Proceduresetc
