All Matches

Solution Library

Expert Answer

Textbooks

Search Textbook questions, tutors and Books

Oops, something went wrong!

Change your search query and then try again

Result Not Found

Books FREE
Tutors
Study Help
Hire a Tutor
AI Tutor New

Search
Sign In
Register

study help
computer science
a practical guide to database design

Questions and Answers of A Practical Guide To Database Design

When using erwin for physical data modeling, what needs to be done to create the DDL to create a new database?
What software product(s) are required to install and use Microsoft Access? Is a Microsoft Access database a logical or physical database?
Where is a Microsoft Access database stored?
How do you assign the DataType for a column in a table?
When creating a table, how are key column(s) identifie
When defining a column in a table, how can an index be created on that column?
When defining an index on a column, does that index have to be unique?
Can a table be created that does not have a unique key?
When creating a table whose key column is an ever-increasing numeric value, what DataType should be used for that column?
What steps are taken to import data into a table?
What steps must be taken to create a Query for three linked tables in the database?
Can columns in a table be updated using a Query?
What steps are followed to create an Update query?
How can you use Microsoft Access to view data in a table in an SQL Server database?
How can you run a query against a table in an SQL Server database using SQL Serverspecific SQL?
How can a table be manually browsed or filtered?
Explain the difference between a RDMS and a relational database.
When doing hardware planning for an SQL Server database, what type of files must be planned for and mapped to disk drives(s)?
If you installed SQL Server on a laptop, how would you configure the database files mentioned in #2?
If you installed SQL Server on a desktop computer with two disk drives, how would you configure/store the database files mentioned in #2?
If you installed SQL Server on a server with RAID 5 disk drives, how would you configure/store the database files mentioned in #2?
When configuring an SQL Server Database Backup, you can choose to overwrite or append the new backup to the output file. Which would you choose and why? What are the ramifications of this decision
When creating a new table, how is the primary key identified?
When creating a table, when is the “Allow null” option selected for a column?
When creating a table whose key column is an ever-increasing numeric value, how is that column defined when it is created?
When defining a column in a table, how can an index be created on that column?
When creating tables for a new database, when are indexes automatically created?
What steps must be taken to create a View of three linked tables in a database?
When defining an index on a column, does that index have to be unique?
What is the significance of a “Clustered Index”?
What does it mean to rebuild an index? When is that done?
What must be done to a PERL scripts being migrated from a UNIX to a Windows platform?
What are search patterns? What purpose do they serve?
Describe a pattern that will detect a date in the format of “mm-dd-yyyy.”
Show the PERL command to change a date string “mm-dd-yyyy” to “yyyy-mm-dd.”
What is the purpose of the split command? Give an example of how it can be used.
What is the purpose of the index operator? Give an example of how it can be used.
When using Microsoft Access as a GUI, name two RDBMS’s that can serve as the source for a database query.
When using Microsoft Access as a GUI, what is a linked table?
When using Microsoft Access as a GUI, how can a complex query using DBMSspecific SQL be executed?
By default, where is a Microsoft Access database installed? What users can run queries against the database?
Compare the use of Microsoft Access and PHP when performing a rapid prototype for a new database application.
Describe the difference between a database Table, a View, and a Query.
By default, what columns have indexes created when a Table is defined?
What is a Form? How does it differ from a Query?
When using the Query wizard to create a query, what does the “View” mode/ button do?
What are the different types of queries supported by Microsoft Access? What does each do?
What is a Pass-Through query? When/Why is it used?
What is an Update query? Why/When is this specified?
Name the system software necessary to provide a web-based interface to a database.
When setting up a PHP server, where are the PHP scripts stored/located?
What code can an external user see when using a PHP script?
What restrictions are there for client systems that must use this interface?
How does PHP know what type of relational database management system is being accessed?
In the scripts shown in the current chapter, what tables were accessed, and how were they updated?
Give the name of the software component that performs verification of the user’s name and password.
In this application, where are user names and passwords stored and managed?
If the first messages were considered important and the user wants to set the Pending flag until more research is done, what steps/selections are made by the user?Figure 11.1 shows the initial
Give the name of the php scripts and how they are used.
When making this update, how is the row being updated mapped to the information on the web page?Figure 11.1 shows the initial display of WarningRecords in the database when the browser is first
The first display of WarningMessages.php has titles for each of the five columns of information from the database. Map each of the title names to columns in the database.
In the WebHeader.php web page, what does the Review/Check Warning Records label represent? What happens when it is selected?Figure 11.1 shows the initial display of WarningRecords in the database

Showing 100 - 200 of 162

1
2

Services

Sitemap
Fun
Definitions
Become Tutor
Study Help Categories
Recent Questions
Expert Questions

Company Info

Security
Copyrights
Privacy Policy
Terms & Conditions
SolutionInn Fee
Scholarship

Get In Touch

About Us
Contact Us
Career
Jobs
FAQ
Campus Ambassador

Secure Payment

Download Our App

© 2024 SolutionInn. All Rights Reserved