Question

1- True/False _______ All access. such as requests to read records, updates, deletions and additions, for data from application programs (apps) related to data residing on a centralized database goes through the DBMS in order to be performed.

2-True/False   ____ When a database is designed, the Database Administrator designates the organization’s single, allowable and standard programming language, such as Java, that must be used by the apps whenever accessing the database.

3- True/False ___ When preparing to design a new database it is generally not worth the time and effort to interview the users, examine existing files, reports and forms because they most likely will be flawed or of little value and can distract the designer from her important tasks related to the new DB.

4-True/False _____ Designing Databases is optimally accomplished by closely following strict database guidelines in order to complete the task by a single focused effort.

Answer 1

Question 1)
Answer: True
Information is transferred between the DataBase Management System (DBMS) and application programs (apps) such as spreadsheets, Word processor, Graphics, or web application program. As the name suggests DBMS creates and manages, application programs perform the processing functions such as reading records, updates, deletions, and additions for data. DBMS is a set of programs that handles a company's database responsibilities. Using DBMS end-users using application programs (apps) can create, read, update, and delete data in a database.

Question: 2)
Answer: False

A Database Administrator (DBA) using specialized software stores and organizes data in a Database. He "may" also involve in Capacity Planning, installation, database designing, configuration, performance monitoring, migration, troubleshooting, security, and backup and data recovery. A DBA would also have database design and implementation and programming skills. However, he/she may design a database, however, may not be the person to decide on which programming language the apps should use to access the database. DBA only manages, administers the database, and may even design the database, when app developers have decided and designated which programming language should be used to access the database.

Hence, it is the app developers who choose the programming language for app development to access databases. Where database designers only determine what data has to be stored and how the data elements interrelate.

Question 3)
Answer: False
The database design team interviews several people to learn who will use it, the purpose of the database, how they are going to use it, they analyze business forms, such as invoices, surveys, timesheets, and comb through any existing or previous data systems that include physical and digital files. They gather existing data to be included in the database. Doing this is a professional best practice as this is very important and crucial.

Question 4)
Answer: True
The database designer's or professional's guide is to exploit indexes, views, storage, etc, while designing the database. Yes, it requires a single focused effort with all the team members in the database designing team to work on the same page following a single focused effort, standardizing the naming conventions, collaborating with one another, etc.

One such guideline is the database naming guidelines. Also, to further help database designers there are good database design guidelines, bad practices, best practices, and things to avoid, all available for database designing.