Question

In: Computer Science

PLEASE ANSWER ASAP 1- The major tool used to draw/construct a logical database design is the...

PLEASE ANSWER ASAP

1- The major tool used to draw/construct a logical database design is the _______________.

2-

The ID field is planned to be the primary key field in the below diagram. No fields are required to be filled/entered.

ID

Equipment Type

Equipment Number

Daily Rate

phone no

1

Back Hoe

10400

$750.00

diesel powered

1

Medium Crane

335

$350.00

plus tax

3

Back Hoe

10020

$650.00

(631) 992-4567

(516) 429-0800

3

Scaffolding

5

Foundation

335

$0.00

11/17/1952

            Give two reasons why the above flat file could not serve as valid database table.

            A)

            B)

3- Queries that can be written after the database has been designed, populated and in use, that were not originally created during the development of the DB, are called

            a) ad hoc

            b) SQL

            c) transactional

            d) user

Solutions

Expert Solution


Related Solutions

Database __________ which is the logical design of the database, and the database _______ which is...
Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time. a) Instance, Schema b) Relation, Schema c) Relation, Domain d) Schema, Instance
True or False: Logical database design is the process of modifying the physical database design to...
True or False: Logical database design is the process of modifying the physical database design to improve performance. The two major logical database design techniques are conversion of E-R diagrams to relational tables and data normalization. Multivalued attributes are not permitted in unnormalized data. A many-to-many binary relationship in an E-R diagram requires the creation of a total of three tables in a relational database. A one-to-one unary relationship in an E-R diagram requires the creation of a total of...
Creating a Database Design Lab 1: Creating a Database Design (Wk 3) - OR - Draw...
Creating a Database Design Lab 1: Creating a Database Design (Wk 3) - OR - Draw with pencil and paper diagram (take photo of it and submit) along with a summary of the diagram you prepared in a Word document. Use the scenario from Assignment 1: Business Rules and Data Models to complete the lab: Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In...
1a. Construct (draw) an E-R diagram representing the conceptual design of the database. Be sure to...
1a. Construct (draw) an E-R diagram representing the conceptual design of the database. Be sure to identify primary keys, relationship cardinalities, etc. State any assumptions you make. 1b. Convert your E-R diagram to the relational schema. Identify the primary keys of ever relation. Consider the following application: An electronics vendor operates both a Web site and a chain of many physical stores. Examples include Best Buy and Circuit City. To find out more about this application, think about any experiences...
. NEED ANSWER ASAP / ANSWER NEVER USED BEFORE, COMPLETELY NEW ANSWER PLEASE Is it always...
. NEED ANSWER ASAP / ANSWER NEVER USED BEFORE, COMPLETELY NEW ANSWER PLEASE Is it always necessary for government to intervene and internalize the profit and the cost externalities? Illustrate your answer using a real world example. ANSWER THROUGHLY 1-2 pages *** IN PARAGRAPGH FORM PLEASE NOT BULLET POINTS COPY AND PASTE Answer in paragraphs, and no picture attachment please. NEEDS TO BE AN ORIGINAL SOURCE ANSWER NEVER USED BEFORE
. NEED ANSWER ASAP / ANSWER NEVER USED BEFORE, COMPLETELY NEW ANSWER PLEASE There are four...
. NEED ANSWER ASAP / ANSWER NEVER USED BEFORE, COMPLETELY NEW ANSWER PLEASE There are four market models: perfect competition, monopolistic competition, oligopoly and monopoly. Briefly discuss the assumptions of each of these four models and give examples of each. Explain the long run economic profit earned by each of the four. Explain how the concept of economic profit might help explain the rationale for the government’s granting of monopolies to those firms that protect their product with a patent....
. NEED ANSWER ASAP / ANSWER NEVER USED BEFORE, COMPLETELY NEW ANSWER PLEASE There are four...
. NEED ANSWER ASAP / ANSWER NEVER USED BEFORE, COMPLETELY NEW ANSWER PLEASE There are four market models: perfect competition, monopolistic competition, oligopoly and monopoly. Briefly discuss the assumptions of each of these four models and give examples of each. Explain the long run economic profit earned by each of the four. Explain how the concept of economic profit might help explain the rationale for the government’s granting of monopolies to those firms that protect their product with a patent....
Please answer the last step for question 1. Answer it asap please. Thanks 1. Consider the...
Please answer the last step for question 1. Answer it asap please. Thanks 1. Consider the following data for three different samples from three different populations:Consider the following data for three different samples from three different populations: Sample 1 Sample 2 Sample 3 0 6 6 4 8 5 0 5 9 1 4 4 0 2 6 T = 5 T = 25 T = 30 G = 60 SS = 12 SS = 20 SS = 14 ∑X2...
. NEED NEW ANSWER ASAP / ANSWER NEVER USED BEFORE NEED NEW ANSWER ASAP / ANSWER...
. NEED NEW ANSWER ASAP / ANSWER NEVER USED BEFORE NEED NEW ANSWER ASAP / ANSWER NEVER USED BEFORE Explain horizontal and vertical analysis. Do some research .explain why these methods are used. What can we learn from horizontal and vertical analysis statements? How can results vary compared to other corporations and why can ratios better than using dollars? ANSWER THROUGHLY 1 page *** IN PARAGRAPGH FORM PLEASE NOT BULLET POINTS COPY AND PASTE Answer in paragraphs, and no picture...
. NEED ANSWER ASAP / ANSWER NEVER USED BEFORE, COMPLETELY NEW ANSWER PLEASE Sam Strother and...
. NEED ANSWER ASAP / ANSWER NEVER USED BEFORE, COMPLETELY NEW ANSWER PLEASE Sam Strother and Shawna Tibbs are vice presidents of Mutual of Seattle Insurance Company and co-directors of the company’s pension fund management division. An important new client, the North-Western Municipal Alliance, has requested that Mutual of Seattle present an investment seminar to the mayors of the represented cities, and Strother and Tibbs, who will make the actual presentation, have asked you to help them by answering the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT