answersLogoWhite

0


Best Answer

* 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 designer
The 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.

User Avatar

Wiki User

10y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

9y ago

A logical database design is to transform all the specification of data in to some basic basic elements. Also which follows the well established rules. Logical database design use normalization to maintain non redundant data.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is a logical database designer?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What are the responsibilities of the database designer?

As the name implies, a database designer develops both the logical and physical design of the database. For hierarchical databases, they define the parent-child relationships and in relational tables, the relations between tables. They also often develop validation rules, constraints and the like.


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


Who is a database designer?

A database designer is a person who specifies how a database records are stored, accessed and related to make sure there is adequate performance!


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.


Physical database designer?

IBM Infosphere Data Architect, CA Erwin, Microsoft Access GUI are examples of physical database designer.


What will represent logical storage of data in database?

view


Who designs a database?

A database or systems designer will do it. They could also have other roles like being an analyst or a database administrator. Whoever is designing a database may work with people in some of those other jobs, particularly when it is a very large system. If it is a small database, then it is easy to design and somebody with a bit of knowledge of databases can design and create one.


What is the primary deliverable from logical database design?

normalized relations


What is logical view of database?

The logical constists of the name of the table, the attributes it contains, their types, the constraints on the attributes, if any.


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