Database Questions Pg.80

In: Computers and Technology

Submitted By swanney
Words 943
Pages 4
Alex Swan
Mr. Davis
9/18/12
Homework Review Questions
3.1 Define the following terms as they apply to the relational model of data:
Domain – Set of atomic (indivisible) values.
Attribute – it describes a component of the database, such as a table or a field.
N-tuple – in mathematics, an ordered set of n elements called its components or coordinates.
Relation Schema – It is representation of database highlighting relationships that we have created.
Relation State – set of tuples that have the same attributes.
Degree of a relation – number of attributes n of its relation schema.
Relational Database Schema – Tables, columns and relationships that make up a relational database.
Relational database state – is a union of all the individual relation states, whenever the database is changed a new state arise.
3.2 Why are tuples in a relation not ordered?
- A Relation is defined as a set of tuples. Mathematically, elements of a set have no order among them: tuples in a relation do not have any particular order. In other words, a relation is not sensitive to the ordering of tuples. Tuple ordering is not part of a relation definition because a relation attempts to represent facts at a logical or abstract level.
3.3 Why are duplicate tuples not allowed in a relation?
- Duplicate tuples are not allowed in a relation because it violates the specifications of the relational integrity constraints, particularly the key constraint which states that no two tuples can have the same values for their attributes at any relation state of a database.
3.4 What is the difference between a key and a superkey?
- Superkey is any subset of attributes that uniquely identifies the tuples of a relation. This subset need not be minimal, that is, one can remove some attributes from it and it is still uniquely identifying. If all redundant attributes are removed you…...

Similar Documents

Database Questions Pg.80

...Alex Swan Mr. Davis 9/18/12 Homework Review Questions 3.1 Define the following terms as they apply to the relational model of data: Domain – Set of atomic (indivisible) values. Attribute – it describes a component of the database, such as a table or a field. N-tuple – in mathematics, an ordered set of n elements called its components or coordinates. Relation Schema – It is representation of database highlighting relationships that we have created. Relation State – set of tuples that have the same attributes. Degree of a relation – number of attributes n of its relation schema. Relational Database Schema – Tables, columns and relationships that make up a relational database. Relational database state – is a union of all the individual relation states, whenever the database is changed a new state arise. 3.2 Why are tuples in a relation not ordered? - A Relation is defined as a set of tuples. Mathematically, elements of a set have no order among them: tuples in a relation do not have any particular order. In other words, a relation is not sensitive to the ordering of tuples. Tuple ordering is not part of a relation definition because a relation attempts to represent facts at a logical or abstract level. 3.3 Why are duplicate tuples not allowed in a relation? - Duplicate tuples are not allowed in a relation because it violates the specifications of the relational integrity constraints, particularly the key constraint which states that no two...

Words: 943 - Pages: 4

Database

...The parts of the system analysis and design are preliminary investigation, system analysis, system design, system developments, system implantations, and system maintenance. The preliminary system is the one of the most tedious task is to recognize the real problem of the pre-installed system. In this stage the analyst makes a survey by gathering all the available information needed for the system elements and allocation of the requirements to the software. The system analysis understands the nature of the information and the functions of the software which is required for the system. The analyst makes a brief survey of the requirements and tries to analyze the performance of the system which is to be developed. The system of design The analyst actually makes number of designs of the system on paper or on the computer and sees to it that the rough image made of the system comprises of all the requirements or not. System coding is the analyst translates the code or the programs in such a way that they become in machine readable form. Once the system is done with the coding stage it tests the systems and sees to it that it is working as per the expectations or not. System implantation is one of the most vital phases as in this phase the analyst actually gives the system to the customer and expects for a positive feedback. Finally, the system maintenance is that the analyst needs to maintain the system and see to it that it working within the standards set. He needs to maintain......

Words: 368 - Pages: 2

Database

...Reasons to get rid of traditional databases Redundancy in defining and storing data Wasted storage space Redundant efforts to maintain common data up-to-date Miniworld - some aspect of the real world Redundancy - *Repetitive storage* of data leading to possible multiple versions and/or ill utilisation of data storage capacity Inconsistency - Failure to adhere to standardised storage of data; usage of varying formats, non-confirmation to standardised/defined methods to store similar/related data. *Design of a new application for an existing database *Design of a brand new database * requirements specification and analysis Transformed to.... * conceptual design(ENTITY-RELATIONSHIP MODEL) that can be represented and manipulated using some computerized tools. Transformed to.... * logical design(RELATIONAL DATA MODEL) that can be expressed in a data model implemented in a commercial DBMS. (In this book we will emphasize a data model known as the Relational Data Model. Transformed to.... * physical design - further specifications are provided for storing and accessing the database Characteristics of the Database Approach 1. Self-describing nature of a database system 2. Insulation between programs and data, and data abstraction 3. Support of multiple views of the data 4. sharing of data and multiuser transaction processing 1. Self-Describing Nature of a Database System @The fact that modern database systems...

Words: 438 - Pages: 2

Database

...Examination Paper: Data Base Management System IIBM Institute of Business Management Semester-I Examination Paper Database Management System Section A: Objective Type (20 marks) • • • This section consists of Multiple Choice Questions & Fill in the blanks / True & False. Answer all the questions. Each Question carries 1 mark. MM.100 Multiple Choices: 1. Structured Query Language (SQL) is the language for working with a. DDBMS b. RDBMS c. Both (a) & (b) d. None of the above 2. Decomposition in database design means a. Breaking one table into multiple tables b. Breaking two table into multiple tables c. Composing multiple tables into one table d. None of the above Locking helps a. Hiding the database b. To solve concurrency problems c. Both (a) & (b) d. None of the above 3. 4. Database optimizer a. Enhances the speed of query execution b. Minimizes the speed of query execution c. Is a program d. None of the above 5. Data is __________. a. Raw facts b. Processed information c. Both (a) & (b) d. None of the above 6. Mobile computing means a. Ability to use computer while on still b. Ability to use computer while on move c. Calculation with the help of mobile d. None of the above IIBM Institute of Business Management 1 Examination Paper: Data Base Management System 7. Operation Data Store (ODS) provides a. Situation sensitive decision support & operational reporting b. Time sensitive decision support & operational reporting c. Both (a) & (b) d. None of the above 8...

Words: 830 - Pages: 4

Database

...",          SUM(DECODE(TO_CHAR(hire_date, 'YYYY'),1997,1,0))"1997",          SUM(DECODE(TO_CHAR(hire_date, 'YYYY'),1998,1,0))"1998"  FROM    employees;  Oracle Database 10g: SQL Fundamentals I A - 13 Practice 4: Solutions (continued) 11. Create a matrix query to display the job, the salary for that job based on department number, and the total salary for that job, for departments 20, 50, 80, and 90, giving each column an appropriate heading. SELECT   job_id "Job",           SUM(DECODE(department_id , 20, salary)) "Dept 20",           SUM(DECODE(department_id , 50, salary)) "Dept 50",           SUM(DECODE(department_id , 80, salary)) "Dept 80",           SUM(DECODE(department_id , 90, salary)) "Dept 90",            SUM(salary) "Total"  FROM     employees  GROUP BY job_id;  Oracle Database 10g: SQL Fundamentals I A - 14 ...

Words: 569 - Pages: 3

Database

...A database is an organized collection of data. The data are typically organized to model relevant aspects of reality in a way that supports processes requiring this information. For example, modeling the availability of rooms in hotels in a way that supports finding a hotel with vacancies. Database management systems (DBMSs) are specially designed applications that interact with the user, other applications, and the database itself to capture and analyze data. A general-purpose database management system (DBMS) is a software system designed to allow the definition, creation, querying, update, and administration of databases. Well-known DBMSs includeMySQL, PostgreSQL, SQLite, Microsoft SQL Server,Oracle, SAP, dBASE, FoxPro, IBM DB2, LibreOffice Base and FileMaker Pro. A database is not generally portable across different DBMS, but different DBMSs can by using standards such as SQL and ODBC or JDBC to allow a single application to work with more than one database. Contents   [hide]  * 1 Terminology and overview * 2 Applications and roles * 2.1 General-purpose and special-purpose DBMSs * 3 History * 3.1 1960s Navigational DBMS * 3.2 1970s relational DBMS * 3.3 Database machines and appliances * 3.4 Late-1970s SQL DBMS * 3.5 1980s desktop databases * 3.6 1980s object-oriented databases * 3.7 2000s NoSQL and NewSQL databases * 4 Database research * 5 Database type examples * 6 Database design and...

Words: 771 - Pages: 4

Database

...Chapter 1 Introduction 1.1 Background Sky Bus is a domestic privatized transportation company that runs the vehicles all over the country. They have several branches at different locations of the country, so that they can provide the transportation facilities between the places. They want an online application to be developed, where the details of the bookings done and the customer will be updated from time to time and one can track the details of the available seats immediately 1.2 Purpose of the System The essence of realizing the proposed system is that the system is supposed to give different services to overcome existing and anticipated problems the services are that the system and by this the purpose of the system in the most precise form is to manage and computerize the traditional database, ticket booking and tracking bus and travel made easy. and most importantly the big customer at large and to provide quality service, update and accurate information. . 1.3 Statement of the problem Over view in this part well try to discuss the differences of the current system which brought about the need for the proposed system .I t is hard to define the problem in a concrete manner considering that there was no single system before hand but we will try to see systems which tries to do each module. Ticketing reservation There was no reservation system and the ticketing was done in long lines of people with first come first served manner...

Words: 814 - Pages: 4

Database Questions Pg.80

... i. FULL NAMES: BAMIGBOLA, AKEEM FEMI ii. PLACE OF BIRTH: ARAMOKO-EKITI DATE OF BIRTH: 25th March, 1987 iii. GENDER: MALE iv. MARITAL STATUS: SINGLE v. NATIONALITY: NIGERIAN vi. STATE OF ORIGIN: EKITI STATE vii. LOCAL GOVT: EKITI-WEST viii. CONTACT ADDRESS: No 5, Oke-Oja Street, Aramoko-Ekiti, Ekiti State, Nigeria. ix. Akeemfastlinks@yahoo.com x. GSM NO: +234 803 765 6313 +234 805 672 8406 xi. ACADEMIC QUALIFICATIONS: B.Sc. [2011] Bachelor of Science in Computer Science [Second Class Upper]     Ekiti State University, Ado-Ekiti (formerly University of Ado-Ekiti)   Ekiti State, Nigeria.   SSCE [2002] Senior School Certificate Examination Victory Royal College, Aramoko-Ekiti, Ekiti State, Nigeria. TRAINING CERTIFICATIONS PROGRAM: [2012] Certification in Sun Java Programming: Anthiis Integrated System Limited  Ado-Ekiti, Ekiti State, Nigeria. [2011] Certification in VB.net Programming: Topstock Computer Technology Offa, Kwara State, Nigeria. PERSONAL SKILLS: • Software Developer: Writing programming code such as Vb.net, Java and PHP. • Excellent knowledge of computer like Microsoft word, Excel, Access, Database computation and internet. WORK EXPERIENCES: NYSC [2012] National Youth Service Corps. Department of...

Words: 480 - Pages: 2

Database

...Project on Database Design for College Library Index: 1. Introduction............................................................................ 3 2. Requirement Analysis ..............................................................4 3. Defining Entitiy and Attribute...................................................5 4. Entity Relationship Diagram......................................................6 5. Non- Technical overview of Entity Relationship Diagram..........7 6. User Applications...................................................................... 7 7. ER Schema................................................................................. 8 8. Data Dictonary ...........................................................................9-16 8.1 Table Library................................................................9 8.2 Table Book....................................................................10 8.3 Table Course.................................................................11 8.4 Table Journal................................................................12 8.5 Table Compact Disc......................................................13 8.6 Table Employee............................................................14 8.7 Table Student...

Words: 2401 - Pages: 10

Database

...A Relation is defined as a set of tuples. Mathematically, elements of a set have no order among them: tuples in a relation do not have any particular order. In other words, a relation is not sensitive to the ordering of tuples. Tuple ordering is not part of a relation definition because a relation attempts to represent facts at a logical or abstract level. 3.3 Why are duplicate tuples not allowed in a relation? - Duplicate tuples are not allowed in a relation because it violates the specifications of the relational integrity constraints, particularly the key constraint which states that no two tuples can have the same values for their attributes at any relation state of a database. 3.4 What is the difference between a key and a superkey? - Superkey is any subset of attributes that uniquely identifies the tuples of a relation. This subset need not be minimal, that is, one can remove some attributes from it and it is still uniquely identifying. If all redundant attributes are removed you get a subset what is called primary key. A key (better: primary key) is the minimal subset of... View Full EssayA Relation is defined as a set of tuples. Mathematically, elements of a set have no order among them: tuples in a relation do not have any particular order. In other words, a relation is not sensitive to the ordering of tuples. Tuple ordering is not part of a relation definition because a relation attempts to represent facts at a logical or abstract level. 3.3 Why are......

Words: 385 - Pages: 2

Database

...Student Database Management System Ajay Shankar Bidyarthy , Abhishek Kumar b.ajay@iitg.ernet.in kumar.ak@iitg.ernet.in November 13, 2012 Abstract: An organized and systematic office solution is essential for all universities and organizations. There are many departments of administration for the maintenance of college information and student databases in any institution. All these departments provide various records regarding students. Most of these track records need to maintain information about the students. This information could be the general details like student name, address, performance, attendance etc or specific information related to departments like collection of data. All the modules in college administration are interdependent. They are maintained manually. So they need to be automated and centralized as, Information from one module will be needed by other modules. For example when a student needs his course completion certificate it needs to check many details about the student like his name, reg number, year of study, exams he attended and many other details. So it needs to contact all the modules that are office, department and examination and result of students. With that in mind, we overhauled the existing Student Database Management System and made necessary improvement to streamline the processes. Administrators using the system will find that the process of recording and retrieving students information and managing their classes...

Words: 4780 - Pages: 20

Database

...Business Plan for The Future Provided Jeremy T. Brooks Liberty University Analysis The business being proposed is called The Future Provided. This business will be a networking/IT consulting agency. Their main duty will be to go into an existing business or new business and determine what technology the business needs to efficiently accomplish their goals. The Future Provided has partnered with Netgear and will provide their equipment when upgrades are needed. The business type will be a sole proprietorship. With this business structure the owner has full control. Entrepreneur.com has this to say about sole proprietorship, “It’s easy to form and offers complete managerial control to the owner. However, the owner is also personally liable for all financial obligations of the business (entrepreneur.com). This structure is appealing because the income and expenses go on the owner’s tax return. One consequence is if the business goes under then the owner is solely responsible for the debts. In terms of legally starting this structure it is by far the easiest. Inc.com had this to say about it, “To be a sole proprietorship, you do not have to take any formal or legal steps at the federal, state, or local level, Weltman says. ‘As long as you are the only owner, you automatically become a sole proprietorship by conducting business,’" (inc.com). This is appealing because of the ease. There are no legal hoops to jump through to start your business. The following...

Words: 1889 - Pages: 8

Pg Management

...This Paying Guest Service is located in Koramangala, Bengaluru, Karnataka, India and is available for Student, Working on Sharing basis. The PG service comes with only a few amenities such as Shoerack, WIFI, Geyser, Bed, Cupboard, Fan, internet, Water Purifier, boys entry, Cooking Allowed, Western Toilet, Attached Toilet. Along with the PG amenities, the residents would also benefit from the services including Parking, Security, Elevator, House Keeping, 24 Hours Water Supply, Power Backup. There are certain restrictions in the PG including Document proof.This Paying Guest Service is located in Koramangala, Bengaluru, Karnataka, India and is available for Student, Working on Sharing basis. The PG service comes with only a few amenities such as Shoerack, WIFI, Geyser, Bed, Cupboard, Fan, internet, Water Purifier, boys entry, Cooking Allowed, Western Toilet, Attached Toilet. Along with the PG amenities, the residents would also benefit from the services including Parking, Security, Elevator, House Keeping, 24 Hours Water Supply, Power Backup. There are certain restrictions in the PG including Document proof.This Paying Guest Service is located in Koramangala, Bengaluru, Karnataka, India and is available for Student, Working on Sharing basis. The PG service comes with only a few amenities such as Shoerack, WIFI, Geyser, Bed, Cupboard, Fan, internet, Water Purifier, boys entry, Cooking Allowed, Western Toilet, Attached Toilet. Along with the PG amenities, the residents would also...

Words: 1329 - Pages: 6

Database

...Chapter 3 The Relational Model Review Questions 3.1 Discuss each of the following concepts in the context of the relational data model: (a) Relation (b) Attribute (c) Domain (d) Tuple (e) Intension and Extension (f) Degree and Cardinality. Each term defined in Section 3.2.1. 3.2 Describe the relationship between mathematical relations and relations in the relational data model? Let D1, D2, . . . , Dn be n sets. Their Cartesian product is defined as: D1 × D2 × . . . × Dn ’ {(d1, d2, . . . , dn) | d1 ∈ D1, d2 ∈ D2, . . . , dn ∈ Dn} Any set of n-tuples from this Cartesian product is a relation on the n sets. Now let A1, A2, . . ., An be attributes with domains D1, D2, . . . , Dn. Then the set {A1:D1, A2:D2, . . . , An:Dn} is a relation schema. A relation R defined by a relation schema S is a set of mappings from the attribute names to their corresponding domains. Thus, relation R is a set of n-tuples: (A1:d1, A2:d2, . . . , An:dn) such that d1 ∈ D1, d2 ∈ D2, . . . , dn ∈ Dn Each element in the n-tuple consists of an attribute and a value for that attribute. Discussed fully in Sections 3.2.2 and 3.2.3. 3.3 Describe the differences between a relation and a relation schema. What is a relational database schema? A relation schema is a named relation defined by a set of attribute and domain name pairs. A...

Words: 3760 - Pages: 16

Database

...IST 792 paper 2 Database security is a growing concern evidenced by an increase in the number of reported incidencets of loss of unauthorized exposure to sensitive data. As the amount of data collected, retained, and shared electronically expands, so does the need to understand database security. (Murray, 2010) Database security concerns the use of a broad range of information security controls to protect databases (potentially including the data, the database applications or stored functions, the database systems, the database servers and the associated network links) against compromises of their confidentiality, integrity and availability. It involves various types or categories of controls, such as technical, procedural/administrative and physical. Database security is a specialist topic within the broader realms of computer security,information security and risk management. Security risks to database systems include, for example: * Unauthorized or unintended activity or misuse by authorized database users, database administrators, or network/systems managers, or by unauthorized users or hackers (e.g. inappropriate access to sensitive data, metadata or functions within databases, or inappropriate changes to the database programs, structures or security configurations); * Malware infections causing incidents such as unauthorized access, leakage or disclosure of personal or proprietary data, deletion of or damage to the data or programs, interruption or denial...

Words: 524 - Pages: 3