Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
An elementary school contains 30 classrooms numbered 1 through 30. Each classroom can contain any number of students up to 35. Each student takes an achievement test at the end of the school year and
What variables are you going to need and what will be their data type.
SQL is the standard language for relational database management systems. Although all vendors comply with the ANSI (American National Standards Institute) standard for SQL, is there much dissimilarity
Consider the following entity and its attributes. INVOICE (Number, CustomerName, CustomerNumber, CustomerAddress, ItemNumber, ItemPrice, ItemQuantity, SalesPersonNumber, SalesPersonName, Subtotal, Tax
A psychological study requires participants to answer a number of questions related to personality. The database should store the multiple choice answers (A, B, C, D) to the questions and information
What is the output of the code corresponding to the following pseudocode?
Normalize the table to be in second normal form.
There are many kinds of entity relationships in a database model. The relationships can be classified by the following things.
There are various name-brand databases that are available in the IT market. The most common database products are Oracle, Microsoft SQL-Server, IBM's DB2 and MySQL.
INVOICE(CustomerNumber, FirstName, LastName, Phone, InvoiceNumber, DateIn, DateOut, ItemType, Quantity, ItemPrice, ExtendedPrice, SpecialInstructions)
A new trend in database services is something called "Cloud Database". what is a Cloud Database and why might you use this? Who are the companies providing this type of service?
Create an ERD (Entity Relationship Diagram) based on the following Summit Sporting Goods scenario. Be sure to follow drawing conventions for readability and clarity.
Organize the following sets of items into hierarchies of classes with typical attributes and methods (names only). Use UML or text as you prefer
Give an example of one of these minimum cardinalities and how it would affect the physical database design. What are referential integrity actions, and how could you use them in your example?
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