Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
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.
Enter 5 students into the database, each having taken at least three of the following four courses ( ISM 3011, ISM 3116,ISM 4133, ISM 4323). Make up unique Z numbers for each student.Make up a five di
Suppose a queue contained the entries A, B, C, D (from head to tail) and suppose that the entries were removed and pushed on a stack one at a time until the queue was empty. What would be the contents
How to connect to a database in ocaml when user is asked about the username and password during runtime..Let suppose when we run the code first it asks for hostname port username and password
Name and describe the three DTDs you have learned about this week. What is the purpose of the DTDs? Select one of the DTDs to research. Identify the pros and cons of the DTD and describe the best circ
Data fields for your instrument should include number of strings, an array of string names representing string names (e.g. E,A,D,G), and boolean fields to determine if the instrument is tuned, and if
All instructors are also students, but clearly, not all students are instructors. In addition to the normal student information, for all instructors, the date that they start working as an instructor
Discuss the various normal forms 1NF, 2NF, 3NF, BCNF, and 4NF. Discuss how normal forms can be transformed from lower normal forms to higher normal forms. Is it always best to move up to a higher norm