Chapter 1 1) What is a good definition for a database? (2) 2) Who is Edgar Codd
ID: 3754347 • Letter: C
Question
Chapter 1 1) What is a good definition for a database? (2) 2) Who is Edgar Codd and what did he do? (4) 3) List the 4 major parts of a STATEMENT OF WORK, and indicate the purpose of each part. (8) 4) How can one identify topics of a database? (10-11) 5) What language do relational databases use? (4) 6) What are some of the advantages of a well-designed relational database? (4-5) 7) Why is it important to document the process of developing a database? (15-16) 8) What are some of the drawbacks of using a spreadsheet like Excel for a database? (2) . Ch. 1 Vocab Chapter 2: 1) What are the main differences between a transaction database and a management 2) When gathering data for a new database what kinds of documents should you look at and 3) What are the four main ways of gathering data we discussed? information system? (27) why? (23) Be to be able to create good interview questions based on documents reviewed. Ch. 2 Vocabulary Chapter 3: 1) What is the difference between a requirement and a business rule? Give Examples. (59, 52) 2) What are 3 types of data requirements? And what does each do?(49) 3) Databases are usually server applications. Explain briefly what that means. (47) . Ch. 3 vocabulary .Be able to identify business rules (52) .Be able to identify requirements (49)Explanation / Answer
Q1) Database - A database is a collection of information that is organized so that it can be easily accessed, managed and updated. Data is organized into rows, columns and tables, and it is indexed to make it easier to find relevant information. Data gets updated, expanded and deleted as new information is added. Databases process workloads to create and update themselves, querying the data they contain and running applications against it.
Q2) Edgar Codd - Edgar F. Codd was a British computer scientist who is credited with formulating the relational model for database management that became the basis for relational database management systems.
This work and Achivements:- He added other important theories to computer science, but the relational model, a very important universal theory of data management, is considered his most important achievement. Between 1960 and 1980 he devised his theories of data arrangement, resulting in his paper A Relational Model of Data for Large Shared Data Banks in 1970, one year after he published a paper inside IBM.
Q3) 4 parts of SOW:-
1. Scope - This section describes the work to be done in a technical manner. If the system to be built is a software system, this section defines the hardware and software requirements along with the exact work to be done in terms of the final system. If there is anything 'out of scope', those areas are also mentioned under a suitable subheading.
2. Location - The location where the work is performed is mentioned under this section. This section also details the hardware and software specifications. In addition to that, a description about human resources and how they work are addressed here.
3. Timelines - This defines the timeline allocated for the projects. It includes the development time, warranty time and maintenance time. In addition to calendar time, the man days (total effort) required to complete the project is also noted.
4. Mode of contract and payments - There are a number of engagement models when it comes to contracting a service provider. In the domain of software development, there are two distinct contract models, fixed bid and a retainer. In fixed bid, the project cost is a constant and it is up to the service provider to optimize the resource allocation in order to maintain the profit margins. The client does not worry about the number of resources, as long as the delivery schedule is met. In the retainer model, the client pays for the number of resources allocated to the project.
Q4) Identify topics for a Database:-
1. Review all the information available on the subject
a.Can reveal how the information is gathered, used, and shared.
2.Identify the features of the potential databasea.
a. Scope or domain of the database
3.Check if nouns cluster into themes (relate to same subject)
Q5) SQL (Structured Query Language) is the most popular relational database language. It implements both a DDL and a DML and concerns itself with the creation, update and delation of relations and properties based on relational algebra and calculus.
Q6) Advantages of well-designed RDBMS:-
The database structure is easy to modify and maintain. Modifications you make to a field or table will not adversely affect other fields or tables in the database.
The data is easy to modify. Changes you make to the value of a given field in a table will not adversely affect the values of other fields within the table. Furthermore, a well-designed database keeps duplicate fields to an absolute minimum, so you typically modify a particular data value in one field only.
Information is easy to retrieve. You'll be able to create queries easily because the tables are well constructed and the relationships between them are properly established.
End-user applications are easy to develop and build. You can spend more time on programming and addressing the data manipulation tasks at hand, instead of working around the inevitable problems that arise when you work with a poorly designed database.
Q8) Disadvantages of using Excel as DB:-
Please let me know in case of any clarifications required. Thanks!
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.