Questions and Answers of A Practical Guide To Database Design

What happens after the script runs and finishes searching for warning and error records?Refer to the PERL script shown in Figures 8.3 and 8.4. C:\Users ex h\Documents\Book SQLServerLogCheck.prl -
In line 42, what is the purpose of the “\” character?Refer to the PERL script shown in Figures 8.3 and 8.4. C:\Users ex_h\Documents\Book\SQLServerLogCheck.prl - Notepad+. Eile Edit Search View
Who would you ask to participate as a member of the design team? Why?You are asked to lead a design team for a new database to be used by your company.
If the attribute “PreferredCreditCard” is to be added, how would the entity/ attribute list change?Referring to the data model shown in Figure 2.8: Customer "Customer Identifier Customer
If information were to be added to track the quality of items sold by a supplier, what changes would be made to the data model?Referring to the data model shown in Figure 2.8: Customer "Customer
What is the difference between the Item Price in Advertised_Item and Selling Price in Ordered_Item?Referring to the data model shown in Figure 2.8:
List five entities you would expect to see in this data model and give a description of each.You are asked to participate in creating a logical data model for a physician’s office.
For each entity, list five attributes that would be appropriate for each.You are asked to participate in creating a logical data model for a physician’s office.
For each entity, what attribute(s) would be appropriate as a key?You are asked to participate in creating a logical data model for a physician’s office.
Develop a data model showing these five entities and their relationships.You are asked to participate in creating a logical data model for a physician’s office.
When developing an initial list of entities for the database, what guidelines would you give the participants on what to consider/not consider?You are asked to lead a design team for a new database
How would you document the entity/attribute lists as they are developed?You are asked to lead a design team for a new database to be used by your company.
What do you feel is the appropriate level for data normalization for the entity/ attribute lists to be developed? Why?You are asked to lead a design team for a new database to be used by your company.
Is the database to be used for implementation a factor at this stage? Why or why not?You are asked to lead a design team for a new database to be used by your company.
As the logical data model is developed, should any significant usage requirements be noted or documented? Why or why not?You are asked to lead a design team for a new database to be used by your
What is the purpose of the $nterms variable?Refer to the PERL script shown in Figures 8.1 and 8.2. C:\Users ex h\Documents\Book SearchForTerms.prl - Notepad++ File Edit Search View Encoding Language
What is the purpose of the $match variable?Refer to the PERL script shown in Figures 8.1 and 8.2. C:\Users ex h\Documents\Book SearchForTerms.prl - Notepad++ File Edit Search View Encoding Language
What records are written to the Out file?Refer to the PERL script shown in Figures 8.1 and 8.2. C:\Users rex h\Documents\Book SearchForTerms.pri- Notepad++ File Edit Search View Encoding Language
What is the purpose of the “if” test in lines 31–42?Refer to the PERL script shown in Figures 8.1 and 8.2. C:\Users ex h\Documents\Book SearchForTerms.prl - Notepad++ File Edit Search View
If you wanted to expand the search to include additional terms, what would you do?Refer to the PERL script shown in Figures 8.1 and 8.2. C:\Users ex h\Documents Book\SearchForTerms.pri- Notepad+.
How are warning messages identified in the input file?Refer to the PERL script shown in Figures 8.3 and 8.4. C:\Users ex h\Documents\Book SQLServerLogCheck.prl - Notepad++ Eile Edit Search View
What are the output files produced when this script runs? Where are they stored?Refer to the PERL script shown in Figures 8.3 and 8.4. C:\Users ex h\Documents\Book SQLServerLogCheck.prl - Notepad++
What relational database management systems could be used to store the database and its tables?A design team supporting a small group of analysts must do a rapid prototype to develop a GUI to be used
Would a .NET framework be appropriate for use to develop the GUI? Why or why not?A design team supporting a small group of analysts must do a rapid prototype to develop a GUI to be used to analyze
Would Microsoft Access be appropriate for use as a GUI? Why or why not?A design team supporting a small group of analysts must do a rapid prototype to develop a GUI to be used to analyze data
Would PHP be appropriate for use to develop the GUI? Why or why not?A design team supporting a small group of analysts must do a rapid prototype to develop a GUI to be used to analyze data collected
Would a .NET framework be appropriate for use? Why or why not?Assume a university environment where hundreds of teachers and administrators have Windows-based computers varying in size and capacity
Would Microsoft Access be appropriate for use? Why or why not?Assume a university environment where hundreds of teachers and administrators have Windows-based computers varying in size and capacity
Would PHP be appropriate for use? Why or why not?Assume a university environment where hundreds of teachers and administrators have Windows-based computers varying in size and capacity and with a
What is the purpose of the “Reset StudentID” query?The remaining questions are based on the Microsoft Access University Database.
When using the query wizard, what tables are needed?A query must be created to display all students associated with a specific department.
To run the query, what can be done to identify/select the DepartmentID of interest?A query is needed to show all students enrolled in any course for a specific department.
What tables must be included in the query?A query is needed to show all students enrolled in any course for a specific Department.
What are the bit settings for new rows after they are loaded into the database?This application is based on continuous updates from a PERL script that loads new rows into the associated tables. The
When designing the query, how are specific columns included or excluded from the output display?A query is needed to show all students enrolled in any course for a specific Department.
What is the purpose of the “Main” form, and what does it contain?A query is needed to show all students enrolled in any course for a specific Department.
When using the Form wizard, what object is typically chosen as the basis for the Form design?A query is needed to show all students enrolled in any course for a specific Department.
If the database design described in Section 10.3 were to be altered to store core data tables in SQL Server, what changes must be made to the table definitions?A query is needed to show all students
When and how are these bit settings changed?This application is based on continuous updates from a PERL script that loads new rows into the associated tables. The display of data from these tables is
Do you consider MYSQL to be a database? Why or why not?
In the context of a database transaction, what is a unit of work? Why is it important?
What are the “ACID” properties of a RDBMS? Why are they important?
In a database recovery operation, what files are used to restore the database? What does each contain?
What’s the difference between a Table and a View?
Given table structure the following table structure, write a SQL query to find the Employee ID and employee name from the Employee table for those assigned to Department
Are SQL queries identical between products such as Microsoft Access, SQL Server and Oracle?
Write a SQL query to find the number of employees in Department 20.
In writing a SQL query, what’s the difference between “=” and “like”?
You are part of a team configuring a mission critical database for failover. What are the issues in locating the failover instance in same building? In adjacent building? In a nearby location?
What are the differences between RAID 0 and 1?
You are asked to install a RDBMS on a desktop computer with two internal drives. How would you configure the system across those drives to provide the best possible backup/recovery protection?
Why are Referential Integrity constraints important?
A new database has a new table for Department and another for Employee as shown in Section 1.5, and Referential Integrity constraints created. Files are available to load each table. Does it matter
In setting up backup/recovery operations for a database for use by your business, what considerations are there in making/storing external backups for the database?
Define the terms entity and attribute and give examples of each.
In developing a new data model for Customers, some having multiple offices, a data requirement for a “Customer Location” has been identified. Is this an entity, or an attribute, and why?
When creating a database table, what data type would you recommend for the various columns with zip codes? Why?
When creating a database table, what data type would you recommend for the various columns with telephone numbers?
The Supplier table in Figure 3.2 has a minimal amount of information. What columns do you recommend be added? Customer **CustomerIdentifier Customer TelephoneNumber CustomerName CustomerStreetAddress
If the physical data model is to be expanded to include information for individual stores associated with each customer, describe in detail what changes need to be made.
As part of the changes made for Question 3, are any changes to Referential Integrity constraints needed? Why or why not?Question 3If the physical data model is to be expanded to include information
Describe in detail what steps to be taken to add the new columns from Question 5 to the Supplier table. How much down time/maintenance time is required?Question 5The Supplier table in Figure 3.2 has
Using the physical data model in Figure 3.2, describe the sequence of tables to be accessed to show all information regarding a customer order and all items on that order. Customer
Are any indexes needed to provide a higher level of performance for Question 7?Question 7Using the physical data model in Figure 3.2, describe the sequence of tables to be accessed to show all
Using the Physical Data Model in Figure 3.2, describe the sequence of tables to be accessed in order to show, for an advertised item, the available suppliers for each that have a customer rating of
What must be changed in the physical data model to store information with customer ratings for items purchased from each supplier?
If the query described in Question 10 runs too slowly, what would you do?Question 10Using the Physical Data Model in Figure 3.2, describe the sequence of tables to be accessed in order to show, for
Using the physical data model in Figure 3.2, for a specific Advertised_Item, describe the sequence of tables to find the Supplier having the lowest price for that item. Are any indexes necessary and
When using Microsoft Access, what steps are necessary to create an Index for a column in a table?
A database has been created based on the physical data model in Figure 3.2, and we find that we frequently need to find Customer records based on their telephone number. What changes need to be made
When using SQL Server, what steps are necessary to create an Index for a column in a table?
Explain the difference between a Logical Data Model and a Physical Data Model.
When does a one-to-many relationship exist between two entities?
Can a Logical Data Model contain a many-to-many relationship? Why/why not?
Is a one-to-one relationship valid? Why/why not?
When describing a column in a table, what is the meaning of the Optional or Mandatory setting?
What information is considered when moving from a Logical Data Model to a Physical Data Model?
What changes would you make to the Physical Data Model to add a telephone number for faculty? Give an example. What Storage format would you use?
What changes would you make to the Physical Data Model to add minimal grade requirements for prerequisite courses? Would this be an Optional or Mandatory column?
What changes would you make to the Physical Data Model to add email address for students and faculty? What Storage format would you use?
What changes would you make to the Physical Data Model to add information on textbooks needed for each course?
In Course Curriculum, what storage format would you choose for the Opt-Mandatory column?
If this university had multiple campus locations, what changes would you make to the Physical Data Model to store information about faculty positions at each campus location?
If this university had multiple campus locations, what changes must be made to the Physical Data Model to track what courses are taught at each location?
What changes must be made to the Physical Data Model to store information regarding graduates?
Faculty members are optionally appointed as course developers. What changes to the Physical Data Model are necessary to track that information?
What is a data modeling tool? How does it help a design team when designing a new database?
What is the difference between a logical data model and a physical data model?
Name two RDBMS products supported by erwin’s physical data modeling software.
What is reverse engineering, and when/how is it used?
What does the erwin reverse engineering file use as input, and what does it produce?
How accurate are the results of a reverse engineering process?
What is the change management process, and why is it important?
Describe the components of a change management system and describe what they do.
When using erwin for logical data modeling, where is the information entered that gives a full definition/description for each attribute?
When defining attributes in a logical data model, what is the purpose of defining/ selecting logical data types?
When using erwin for logical data modeling and defining a new entity and its attributes, how is the key column identifie
After creating tables in a logical data model, how are one-to-many relationships identified?
After creating a logical data model, what needs to be done to create a matching physical data model?
When creating a physical data model, when/how are referential integrity constraints created?

Showing 1 - 100 of 162