DATABASE SYSTEMS CLASS: 1. You have a table that contains the following fields: MemberLastName, MemberFirstName, Street,...
DATABASE SYSTEMS CLASS:
1. You have a table that contains the following fields: MemberLastName, MemberFirstName, Street, City, State, PostalCode, and MembershipFee. There are 75,000 records in the table. What indexes would you create for the table, and why would you create these indexes?
Homework Answers
The fields of the table are MemberLastName, MemberFirstName, Street, City, State, PostalCode, and MembershipFee. The table which contains 75000 records.
Creates a multiple column index on the table, Multiple column index is created on particularly non primary key columns, those may not be single for each record.
- If the record is not unique in the given table, then group the two or more columns to get the single value and create index on that column.
- These Multiple column indexes is used to get the records from the given table and those are quickly retrieved in efficient manner with the help of Multiple column indexes.
Add Answer to:
DATABASE SYSTEMS CLASS:
1. You have a table that contains the following fields:
MemberLastName, MemberFirstName, Street,...
If you were building a database table that contains the following attributes/fields: date, social security number,...
If you were building a database table that contains the following attributes/fields: date, social security number, and phone number fields, how would you define each field (char, text or numeric, et.) and why? 2) Explain how and when it is appropriate to use the following SQL clauses/statements: a. GROUP BY vs. ORDER BY b. WHERE vs. HAVING
4. Referring to the database table below, answer the following questions. a. How many records are...
4. Referring to the database table below, answer the following questions. a. How many records are there? b. How many fields are there? c. How many records would be listed for a query with the STATE ZIP BALANCE CUSTOMER NAME NUMBER 810 STREET CITY John T. Smith 31 Cedarcrest Boulder CO80302 Sally Jones 725 Agua Fria William Holmes 3269 Fast Lane Boulder CO80302 10.00 0 150.35 3.50 criteria State is "CO" and the 775 Sally Jones 725 Agua Fria Santa...
Sample data is provided for the database for the sales system. Using the sample data, you...
Sample data is provided for the database for the sales system. Using the sample data, you will determine the entities, key components of the entities, and business rules for the entities. Using the entities and business rules you will then create an ERD. Tasks: 1. For each entity provide the name, description, fields, data type, primary key, and foreign key. 2. For each direct entity type pair, provide the business rules. 3. Provide the ERD. Customer Table Customer ID, Last...
please help me do it CHAPTER 1 ACCOUNTING SYSTEM INSIGHTS 17 Field H G B A...
please help me do it
CHAPTER 1 ACCOUNTING SYSTEM INSIGHTS 17 Field H G B A STATE ZIP CUSTOMER No LAST NAME FIRST NAME COMPANY NAME STREET ADDRESS CITY 1 54911 Appleton WI 13 Joseph Ave 127127 Ashuer Angela 2 Record 56100 Tuscany Pisa 58 Dante 913691 Pico EspressoBar Vincent Customer FIGURE 1.12 Fields and Records How many fields do you see in Figure 1.12? How many records are in Fiqure 1.12? CTION OF RELATED RECORDS A database table is...
Write a class named Address that takes four strings that represent the fields of any address...
Write a class named Address that takes four strings that represent the fields of any address as private member variables. For example: Street = "456 mission street" City = "Hayward" State = "CA" zip code = 94542 To display any address you use the cout << operator in the main function to display any "Address" object created. You should overload the operator to work with the Address class. The class also has another member function named "displayAddress" that prints the...
Create a FUNCTION that will print out an address label for the TAL Distributors database using the Customer table. You c...
Create a FUNCTION that will print out an address label
for the TAL Distributors database using the Customer table. You can
specify the customer table to output the address.
Here is an example of the output expected:
Toys Galore
28 Laketon St.
Fullton, CA 90085
The database name is "TAL Distributors" and images of
all the tables have been attached. Please double check that
function executes before answering.
Customer Table:
SQLQueryl.sgl . (L (SOM.Jonesl58 (54)) × SELECT TOP (1000) [Customer-Num]...
Arrays Artistic Solutions wants to keep track of 100 of customers, including the following fields: Customer...
Arrays Artistic Solutions wants to keep track of 100 of customers, including the following fields: Customer ID Last Name First Name Street Address City State Zip Code Phone Number Email Address Without access to a database program, you decide that keeping this information in one or more arrays is the best solution. The question is, what kind or kinds of arrays would you use? Discuss whether any or all of the following is suitable for this application, indicating why you...
Create a class named Horse that contains data fields for the name, color, and birth year....
Create a class named Horse that contains data fields for the name, color, and birth year. Include get and set methods for these fields. Next, create a subclass named RaceHorse, which contains an additional field that holds the number of races in which the horse has competed and additional methods to get and set the new field. Write an application that demonstrates using objects of each class. Save the files as Horse.java, RaceHorse.java, and DemoHorses.java. Program 1 Submission Template Fields:...
HELP DATABASE QU Question 1: Think About the relational database table data as given below, write...
HELP DATABASE QU
Question 1: Think About the relational database table data as given below, write the following queries in Oracle SQL. Company (Cid, Cname, City, Budget, Branch) Department (Deptno, Dname, Building, Cname) Employee (Ename, Deptno, Street, City, Phone, Salary) Works (Ename, Deptno, Hire_date) Location (Cname, Location ) 1. Write Query to Create the Company table, suggest appropriate data type of each attribute, consider that there should be a name for each company. 2. Find employee name/names who live in...
Based on the CREATE TABLE statements, make an ER model of the database. Give suitable names...
Based on the CREATE TABLE
statements, make an ER model of the database. Give suitable names
to the relationships. (Remember cardinality and participation
constraints.) The diagram must use either the notation used in the
textbook (and the lectures) or the crow’s foot notation. To save
you some time: There are a few tables that include the following
address fields: Address, City, State, Country and PostalCode (and
the same fields with the prefix Billing-). You are allowed to
replace these attributes...
4. Referring to the database table below, answer the following questions. a. How many records are there? b. How many fields are there? c. How many records would be listed for a query with the STATE ZIP BALANCE CUSTOMER NAME NUMBER 810 STREET CITY John T. Smith 31 Cedarcrest Boulder CO80302 Sally Jones 725 Agua Fria William Holmes 3269 Fast Lane Boulder CO80302 10.00 0 150.35 3.50 criteria State is "CO" and the 775 Sally Jones 725 Agua Fria Santa...
please help me do it
CHAPTER 1 ACCOUNTING SYSTEM INSIGHTS 17 Field H G B A STATE ZIP CUSTOMER No LAST NAME FIRST NAME COMPANY NAME STREET ADDRESS CITY 1 54911 Appleton WI 13 Joseph Ave 127127 Ashuer Angela 2 Record 56100 Tuscany Pisa 58 Dante 913691 Pico EspressoBar Vincent Customer FIGURE 1.12 Fields and Records How many fields do you see in Figure 1.12? How many records are in Fiqure 1.12? CTION OF RELATED RECORDS A database table is...
Write a class named Address that takes four strings that represent the fields of any address as private member variables. For example: Street = "456 mission street" City = "Hayward" State = "CA" zip code = 94542 To display any address you use the cout << operator in the main function to display any "Address" object created. You should overload the operator to work with the Address class. The class also has another member function named "displayAddress" that prints the...
Create a FUNCTION that will print out an address label
for the TAL Distributors database using the Customer table. You can
specify the customer table to output the address.
Here is an example of the output expected:
Toys Galore
28 Laketon St.
Fullton, CA 90085
The database name is "TAL Distributors" and images of
all the tables have been attached. Please double check that
function executes before answering.
Customer Table:
SQLQueryl.sgl . (L (SOM.Jonesl58 (54)) × SELECT TOP (1000) [Customer-Num]...
HELP DATABASE QU
Question 1: Think About the relational database table data as given below, write the following queries in Oracle SQL. Company (Cid, Cname, City, Budget, Branch) Department (Deptno, Dname, Building, Cname) Employee (Ename, Deptno, Street, City, Phone, Salary) Works (Ename, Deptno, Hire_date) Location (Cname, Location ) 1. Write Query to Create the Company table, suggest appropriate data type of each attribute, consider that there should be a name for each company. 2. Find employee name/names who live in...
Based on the CREATE TABLE
statements, make an ER model of the database. Give suitable names
to the relationships. (Remember cardinality and participation
constraints.) The diagram must use either the notation used in the
textbook (and the lectures) or the crow’s foot notation. To save
you some time: There are a few tables that include the following
address fields: Address, City, State, Country and PostalCode (and
the same fields with the prefix Billing-). You are allowed to
replace these attributes...
Most questions answered within 3 hours.
-
The factory method and the abstract factory pattern use
different object oriented
mechanisms are used to...
asked 2 hours ago -
Given the data below for the monthly sales data at each branch in
your region for...
asked 2 hours ago -
Blossom Company owns 10000 of the 50000 outstanding shares of
Taylor, Inc. common stock. During 2018,...
asked 4 hours ago -
Calculate the following: ***SHOW ALL WORK!!!! Or
NO CREDIT*** Circle your answers. 8pts
each
In the...
asked 5 hours ago -
Bank Z is currently advertising interest rates on its checking
account. They claim to pay an...
asked 5 hours ago -
List two ways of transformation on the response variable that
can be used to deal with...
asked 6 hours ago -
If a 2000 ohm resistor has a -3.90 mA current going through it.
What is the...
asked 6 hours ago -
Please comment on the sentences.
Some types of jobs require more training than others. Some
companies...
asked 7 hours ago -
The )G01 for the hydrolysis of phosphorarginine
reaction depicted below is –32 kJ mol-1.
Phosphoarginine ...
asked 8 hours ago -
Cross a heterozygous blue-eyed goat with a homozygous brown-eyed
goat. Be sure to indicate which kids...
asked 8 hours ago -
Use the following information to answer the next two
questions.
Please refer to question 9-90. A...
asked 8 hours ago -
A solution containing 0.050 g of an unknown electrolyte in 2.50
g of cyclohexane was found...
asked 8 hours ago