Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Would you like to tell us a little bit on what's data mining? Also, could it be used to help a decision maker to make appropriate decision?
Consider the following tables in a relational database. Provide the appropriate "SELECT" SQL statement necessary to answer the queries that follow. Primary keys are underlined and foreign key fields h
Based on the job_title_code passed into the procedure, return the job_title_code, job title, and the maximum salary for that
Inventory Items (According to the company's purchasing guidelines, each inventory item can be purchased from only one vendor) ItemNo VendorNo Description QtyOnHand
Given four files named winter2003.txt , spring2003.txt , summer2003.txt , fall2003.txt , define four ifstream objects named wntr , sprg , sumr , and fall , and use them, respectively, to open the four
Explain the difference between good and bad table structures be sure to discuss how you recognize the difference between good and bad structures and what role does normalization play in good and bad t
Databases are a key and important part of information systems. If information cannot bestored in a logical and sensible way, it is very hard for users to get access to the saved information that they
Consider a relational database management system (RDBMS) such as we have discussed in class, specifically: PostgreSQL, MySQL (open source or commercial), IBM's DB2, Oracle RDBMS or Microsoft
Design a database to keep track of information for an art museum. The museum has many art objects. Each art object has a unique number, title, year, description and information about the author it was
Let's take a closer look at the DBA's role with regards to the policies related to databases. What kind of policies would a company have regarding databases? How would a DBA be involved in enforcing t
After your database was put into production, a design flaw was discovered! One of the relationships modeled as a 1:N relationship was really an N:M relationship. The database issue invoves the followi
Business requirements are enforced by implementing database constraints on tables and columns. The database constraints available include the following.
Date query, The company wants to offer an incentive of free shipping to those customers who have not returned for two months. Create a procedure named PROMO_SHIP_SP that determines who these customers
Why it is necessary to choose appropriate data types for each data column?
You are as a database administrator for a small reseller company to implement and adminster the database component of their main application. the data model of this application is presented in figure
How must a database designer balance the time to complete data modeling steps with the benefits the data modeling process offers in creating a database? Consider examples from your work place and clas
We've been focusing on operational databases, often called online transaction processing (OLTP) systems. These OLTP systems handle the day-to-day business of the company and are accessed by multiple u
Databases are designed to allow multiple users to have concurrent access to data. Yet this capability presents certain problems. Investigate how databases resolve multiple concurrent data management i
For those departments that have no majors taking a College Geometry course, print the department name and the number of PhD students in the department.
There are two parts to this work. The first part is to create a database and some tables which will be appropriate for the Batty League Flea Market. That portion of the assignment should be completed
Describe a relational database in detail, including the elements that make up a database such as tables, records, fields, keys and so on.
Building an Access Control System As a member of the Information Security team at a small college, you have been made the project manager to install an access control system (ACS) in a dormitory
The university keeps track of each student's name (SNAME), student number (SNUM), social security number (SSSN), current address (SCADDR) and phone (SCPHONE), permanent address (SPADDR) and phone (SPP
ABC Bank has many branches. Each branch has a unique name, an address (including No., Street, District, City, and Region), phone numbers, fax numbers, email, and total number of employees wo
Describe how relationship between entities are defined, refined, and incorporated into the database design process.