Share
Explore BrainMass

Databases

Oracle9i Database

1. How can this be corrected? 2. Fix the view. SELECT C.CLIENT_ID, C.FIRST_NAME, C.LAST_NAME, COUNT(W.AD_ID) NUMBER_OF_ADS FROM CLASSMATE.CLIENTS C JOIN CLASSMATE.WANT_AD W ON C.CLIENT_ID = W.AD_OWNER GROUP BY C.CLIENT_ID, C.FIRST_NAME. C.LAST_NAME

Databases

As a team you will be responsible for completing the following actions: Part 1 Create a role for a user to complete imports and exports of data. This role should be a user-defined role with the minimum appropriate permissions for a user who would complete imports and exports. Take screen shots of the critical role creatio

Access Database & ER Diagram: Student database

The distinguished Professor Dumbledore has asked me to assist in designing a database to handle the school. I am respectfully passing his request on to you. Build a database, including forms reports and queries, to handle the H. School Management System, or HSMS in short, described below. Remember all data are inserted, updated,

Database Design

1. How are recursive relationships handled? 2. Discuss surrogate keys. 3. Describe the six default referential integrity actions. 4. How are N:M relationships implemented? 5. Why are null values ambiguous?

Describe how these quotes related to database.

Please see the quotes below and describe how they relate to database. quote1-Physical constraints quote2-The principle of mapping quote3-cultural constraints quote4-Make things visible quote5-great precision is not required

Drawing a Dependence Diagram

Using Microsoft Word, complete the following: The following table shows a table called Grade Report for a university. The existing functional dependencies are described as follows: Student_ID -> Student_Name, Major Course_ID -> Course_Title, Instructor_Name, Instructor_Location Student_ID, Course_ID -> Grade Instruct

Event Diagrams

Please see the attached file for background information. Problem: Draw Event Diagrams for each of the events shown in the attached Use-Case Matrix.

Context Data Flow Diagram

Please see the attached file for necessary information. Problem: Draw a Context Data Flow Diagram based on the attached information.

Entity Relationship Modeling

Looking to build an entity relationship model. --- Question 1 The manager of the Ogre Hostel, needs you help in building an IT to manage the hostel. Visitors come from all over to the woodlands to their annual reunion at the hostel. Cutting costs, visitors share rooms. Rooms have numbers and are of various types. Room ty

Revise Relational Database Schema

13.4 Assume that GAP is developing its database using object-oriented methods. Assume further that the database designers want to make some changes to the class diagram on next page. Specifically, they want to make ProductItem an abstract parent class (entity) from which more specific product classes are specialized. Thre

Sequence and equation

Place the following terms into a logical sequence. Tell why you chose this sequence.(Note: Present your reordered terms in your suggested sequence. Do not use numbers or other methods to indicate the changed sequence.) Character Data Warehouse Database

Business Rules

Need to do business rules for the following: Scenario - Discuss database design: 1. Colors for models: a. Classic red, blue, green b. Competition: silver, black c. RoboZid: baby blue, pink, yellow. 2. Personalizaton limits: a. Classic: 1 line, 12 letters b. Competition 2 lines

Question About ER Diagram

The State and Capital relations, shown in the attached figure are described as follows: - State (StateAbbrev, StateName, EnteredUnionOrder, StateBird, StatePopulation) - Capital (Capital Name, State Abbrev, YearDesignated, PhoneAreaCode, CapitalPopulation) - Foreign key: StateAbbrev to State relation - Add the attribute

Please answer me for these questions in detail for each question.

Exercise 1 In the following exercises, you will use the data in the Premiere Products database (shown in the attachment). Explain how you would use SQL to obtain the desired results: 1.Craete the TopLevelCust view described in the following: Using data from the Premiere Products database, define a view named TopLevelCust.

Discussing the Concept of Normalization

Question: In your own words, explain the concept of normalization. What does normalization accomplish? What are the advantages of normalization? In general, how do you go about normalizing a relation?

Intro to database - Crow's Foot model; ERD; Entities

Meridian News publishes a daily newspaper and would like a database developed to maintain information about subscribers and subscriptions. Each subscriber is uniquely identified by a subscriber number and is also characterized by first name, last name, address, and phone number. Each subscription is uniquely identified by a subs

Database systems - conversion: unnormalized relation, 1NF, 2NF, 3NF

Nazca Cinemas is a small movie theater that would like you to design a movie scheduling database system for them. The theater has four rooms (screens). Each room has its own unique ID and the seating capacity and screen size for each are recorded. Each movie is assigned a unique movie ID and its title and runtime are recorded.

Database - conversion: unnormalized relation, 1NF, 2NF, 3NF

The following unnormalized relation shows a modified version of the Nazca Cinemas case problem. A ShowingID attribute has been added to the relation. Each individual showing (a given movie in a given room on a given date at a given time) of a movie is given its own unique ShowingID. Using the modified version of the unnormalized

Intro to Database

Please help with review questions ... 1. List the entities shown 2. What is the primary key for each entity? 3. Are there any multivalued attributes shown? If so, discuss how it/they should be handled in the implementation of the relational database ... (Please see attachment for figures and complete list of questions.

Data Fields Microsoft Words

Using Microsoft Word, list all of the data fields that would be needed for a sales contact database system. Think of it as an extended address book with additional fields to keep track of things that interest salespeople. The only requirements are that you must consider how to store notes about the contact, track any follow up

Please explain the following

Professional Litigation User Services (PLUS) is a company that creates all types of visual aids for judicial proceedings. Clients are usually private law firms, although the District Attorney's office has occasionally contracted for its services. PLUS creates graphs, maps, timetables, and charts, both for computerized presentati

SQL STATEMENT PROBLEM

I am using Microsoft SQL Server 2000 1. Using the tables in the attached doc, write Microsoft SQL statements to enter ten more records into the for each table. There are 9 tables to this database To get me started I need SQL script example for each table and I will fill out the 9 other records.

MS SQL STATEMENTS

I am using Microsoft SQL Server 2000 1. Database Tables TABLE: Employees Job_title_code Social_security_number Last_name First_name Address City State Zip_code Telephone_area_code Telephone_number Email_address Hire_date Salary TABLE: Job_

Database Design: Normalization

See attach file for details and charts. 1. The following exercises are based on the Premiere Products database. Using your knowledge of Premiere Products, determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of

Auto form

Please refer to access_11 questions and make changes on database. (please change the file extension to access) The following is also in the attachment 1. Create an AutoForm based on tblOrders. Name the AutoForm object frmOrders. Change the contents of the title bar of the form so that when it dis