Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
You are the CIO of the newly established Data Mining, Inc. (DMI), a company that specializes in collecting, storing, and analyzing data on customer purchasing habits and then selling its findings to l
Using the EMP and DEPT tables, show a list of all department names and the names of all employees for each department. Be sure to show all departments whether there is an employee in the department or
A Relational Model of Data for Large Shared Data Banks", by Dr. Edgar F. Codd, was published in June 1970 in the Association for Computing Machinery journal. Codd's model became widely accepted as the
The library System stores 3 type of informations:
The lucky Dog Grooming Parlor maintains data about each of its clients in a table named tblClients. Attributes include each dog's name, breed, and ownder's name, all of which are text attributes. The
What are some of the key differences between a flat file and a relational database? Which of the two storage methods do you think is most useful in a real-world application?
A new supplier, RGF (Really Good Food) has been approved. RGF supplys all the same items as CBC, but 50 cents cheaper. Show the insert statements required to enter this information into the l_foods an
The security accounts manager (SAM) database contains information on all user profiles. User account set-up populates the database. Describe the fields and options associated with user account set-up.
Create an XML file that's the equivalent of this database. Enter some data - let's say 2 racetracks, 8 horses, 10 races, and 15 results. The data can be real or fictional.
Design a database for Ray. He is interested in movies and wants to keep information on movies, actors, and directors in a database. The only user is Ray, and he needs to produce the following reports:
Student(sum: integer, sname: string, major: string, level: string, age: integer) Class(name: string, meets at: time, room: string, fid: integer) Enrolled(snum: integer, cname: string) Faculty(fid: int
Describe what the term "data redundancy" means in database design. Explain if it is bad and if a normalized database design is always the best design. Discuss the pros and cons of a normalized databas
Provide the SQL, save it as Q5A.sql that will crate the Video_ Title table. The table contain information about videos in a database.
List the functional dependencies in the following table that concerns invoicing (an application Premiere Products is considering adding to its database), subject to the specified conditions. For
Suppose that you want to make this data model national. Change your answer to B so that it can be used for other metropolitan areas. Change your answer in A for this situation. Specify the entity iden
What data management problems have arisen? How has MySpace solved or attempted to solve these problems?
Design and implement a set of classes to model the employees of a hospital: doctor, nurse, administrator, etc. Include methods in each class that are named according to the services provided by that r
Microsoft Access is uniquely different from most other relational database software. What features are present in Access, but not in Oracle, or SQL Server? Postulate why Microsoft chose to adopt this
Specify the foreign keys for this schema, stating any assumptions you make. Next, populate the relations with a few example tuples, and then give an example of an insertion in the SALES and SALESPERSO
The Database System doesn't have to contain a GUI directly within it. For example, you can use Excel, Access, even MS Visio as a GUI to a SQL Server Database or an Oracle Database. With that being sai
The first part is to create a database and some tables which will be appropriate for a home-budgeting application. That portion of the assignment should be completed from the MySQL console command lin
Cardinality constraints whenever possible. List details that will affect the eventual design but have no bearing on the conceptual design. List the semantic separately. Draw an EER diagram of the libr
There are many problems with securing enterprise databases, far more than IT industry would care to acknowledge. Research and discuss one particular database security issue. How can this problem be ad
If a "student signs up for a class," which type of relationship would you use to model the relationship between the two?