0
IBM Infosphere Data Architect, CA Erwin, Microsoft Access GUI are examples of physical database designer.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
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!
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.
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.
An individual trained in the design and building of databases is called a database?
A database designer or database administrator.
Why the data dictionary is called the database designer's database?
1- Because it records the design decisions about tables and their structures… 2-
What are the various types of database users?
1) End User 2) Database Admin 3) Database Designer 4) System Analysts and Programmers 5) System Administrator *Database Systems 8th Edition
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.
Role of high-level data model in the database design process?
A high level data model serves the database designer by providing a conceptual framework in which to specify, in a systematic fashion, what the data requirements of the database users are, and how the database will be structured to fulfill these requirements.
What are the physical demands of an interior designer?
Everything is needed.
What is level data?
three levels of data abstraction are: 1. Physical level : how the data is stored physically and where it is stored in database. 2. Logical level : what information or data is stored in the database (like what is the datatype or what is format of data. 3.View level : end users work on view level. if any amendment is made it can be saved by other name. for the database to be usable it must retrieve data efficently.this efficency led designer to use complex data structure in the database
What is structural level?
three levels of data abstraction are: 1. Physical level : how the data is stored physically and where it is stored in database. 2. Logical level : what information or data is stored in the database (like what is the datatype or what is format of data. 3.View level : end users work on view level. if any amendment is made it can be saved by other name. for the database to be usable it must retrieve data efficently.this efficency led designer to use complex data structure in the database
What subjects do you have be good at to be a game designer?
well, maybe math, ELA, computer graphics, computer database, etc.
