In terms of the ANSI-SPARC architecture, when designing a database, a determination of the general types...
In terms of the ANSI-SPARC architecture, when designing a database, a determination of the general types of queries that the database should be able to support should be done during:
|
queries are not a consideration in the database design process |
|
|
the logical design phase |
|
|
the physical design phase |
|
|
the cartographic process |
|
|
the conceptual design phase |
Homework Answers
PLEASE FIND THE ANSWER(S) and EXPLANATION
BELOW.
OPTION E
EXPLANATION:
The general types of queries that a database should be able to support will be determined in the early stages of the design process.
The stages in the ANSI-SPARC are:
- Conceptual design phase
- Logical Design Phase
- Physical design Phase
Hence, the early stage is the Conceptual design phase in which we decide the types of Database Queries that our design support!!
In the logical design phase, we design the ER diagrams and stuff.
In the physical design phase, the actual storage is designed.!!
Add Answer to:
In terms of the ANSI-SPARC architecture, when designing a
database, a determination of the general types...
Your hypothetical employer, X University, is pleased with feedback you offered on suggestions about potential types...
Your hypothetical employer, X University, is pleased with feedback you offered on suggestions about potential types of databases and is also please with your suggestions on various Systems Development Life Cycle methodologies. This would be a relational database model for a payroll system that will be standalone but will need to have ability to communicate with other ODBC and SQL Server databases. The overall purpose of the database will be to input employee data for 100-150 employees. The database will...
Written Assignment#1: Preliminary Database Design Preliminary Database Design The purpose of this project is to give...
Written Assignment#1: Preliminary Database Design Preliminary Database Design The purpose of this project is to give you some experience in database design. We will explore both theoretical and practical aspects of the database design steps. Once you master it well, it is a simple matter of translating the theoretical concepts you developed into the terms of a concrete DBMS to implement the database. Conceptual/Logical Database Design You must choose some facet of real life that you feel needs to be...
Hide/Show Time Remaining Part 1 of 1- Question 1 of 38 When designing a new database,...
Hide/Show Time Remaining Part 1 of 1- Question 1 of 38 When designing a new database, the first question users should ask themselves is O A. How much information is going to be stored in this database? B. Where should this database be stored? O C. Who is going to use this database? O D. What questions should this database be able to answer? Question 2 of 38 When linking two tables in a relational database, a user will use...
CO 4) In terms of data types and their uses, which one of the following is...
CO 4) In terms of data types and their uses, which one of the following is NOT correct? The TEXT data type can be used for Last Name. The Date/Time data type can be used for 10/31/2012. The Currency data type can be used for Account balance. The AutoNumber data type can be used for Customer Name. Flag this Question Question 125 pts (CO 5) All of the following describe form usage except a form user should have less input...
Your project will require you to develop a database design to solve a real-life data management...
Your project will require you to develop a database design to
solve a real-life data management problem. It can be any problem in
your work environment or for another organization, for example, a
bookstore (think of how Amazon uses databases), a course management
system (think of how a university manages courses), a bank (think
of how your bank works), and an online auction site (think of how
Ebay works). You will develop a database to solve this problem
You will...
You will develop an E-Commerce database used to maintain customers, products and sales information. You are...
You will develop an E-Commerce database used to maintain
customers, products and sales information. You are required to 1)
gather and analyze requirements 2) design logical structure of the
database 3) create stored procedures to develop the tables and
insert the data 4) write SQL statements for data extraction and
reporting.
Throughout the course of this semester you have analyzed the
requirements for an eCommerce database, designed and developed your
database. As a class we have gone through the process...
This assignment allows students to demonstrate their skills in the area of designing relational databases to...
This assignment allows students to demonstrate their skills in the area of designing relational databases to satisfy specific business rules and requirements. The deliverables for this assignment include an Entity Relationship Diagram and detailed documentation describing the database design and structure. In this assignment you will be provided with a description of an application (below) to create an entityrelationship diagram (ERD) and design accompanying table layout using sound relational modeling concepts and practices. The relationships between the entities and the...
Chapter 13 System Implementation 1) "Examine response time when backing up server data" refers to which...
Chapter 13 System Implementation 1) "Examine response time when backing up server data" refers to which kind of test type? A) Recovery B) Security C) Performance D) Stress 2) What is the purpose of system implementation? A) To replace an entire system. B) To test the methodology for completeness. C) To convert the physical system specifications into work and reliable software and hardware. D) To make the client happy. 3) During the installation process, the analyst can control all of...
(+10) Answer the following questions in terms of the structure chart below. A. What modules directly...
(+10) Answer the following questions in terms of the structure
chart below.
A. What modules directly use
the services of module E?
a. A C
D
b. B
C
c.
D
d. None of these
B. The services of which
modules are directly used by module A?
a. C and
D
b. B C D
c. B D d. B C
(+5) Based on the same structure above, in which module does the
data item w originate?
a.
B ...
A test specification provides designers with what needs to be known in order to perform a...
A test specification provides designers with what needs to be known in order to perform a specific test, and to validate and verify the requirement to be tested. The test script is divided into the test script, which is the generic condition to be tested, and one or more test cases within the test script. Provide a test script and test case for at least 3 of your requirements identified in your requirements specification. Provide the following format for an...
Hide/Show Time Remaining Part 1 of 1- Question 1 of 38 When designing a new database, the first question users should ask themselves is O A. How much information is going to be stored in this database? B. Where should this database be stored? O C. Who is going to use this database? O D. What questions should this database be able to answer? Question 2 of 38 When linking two tables in a relational database, a user will use...
Your project will require you to develop a database design to
solve a real-life data management problem. It can be any problem in
your work environment or for another organization, for example, a
bookstore (think of how Amazon uses databases), a course management
system (think of how a university manages courses), a bank (think
of how your bank works), and an online auction site (think of how
Ebay works). You will develop a database to solve this problem
You will...
You will develop an E-Commerce database used to maintain
customers, products and sales information. You are required to 1)
gather and analyze requirements 2) design logical structure of the
database 3) create stored procedures to develop the tables and
insert the data 4) write SQL statements for data extraction and
reporting.
Throughout the course of this semester you have analyzed the
requirements for an eCommerce database, designed and developed your
database. As a class we have gone through the process...
(+10) Answer the following questions in terms of the structure
chart below.
A. What modules directly use
the services of module E?
a. A C
D
b. B
C
c.
D
d. None of these
B. The services of which
modules are directly used by module A?
a. C and
D
b. B C D
c. B D d. B C
(+5) Based on the same structure above, in which module does the
data item w originate?
a.
B ...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 11 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 11 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 11 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 11 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 11 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 11 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 11 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 11 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 11 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 11 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 11 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 11 months ago