INTRODUCTION TO MS ACCESS CH 4 STD VIII Q1. Very short answer type questions. i. The full form of RDBMS is Relational Database Management System. ii. Row wise information in table is called record. iii. The information stored column wise in a table is called fields. Q2. Short answer type questions. i. Information in a database is stored in a tabular format consisting of rows and columns i.e. a table organizes the data in the form of rows (records)and
Words: 336 - Pages: 2
Question 1 0 out of 4 points | | | The portion of the database that a user is authorized to see is called aAnswer | | | | | Selected Answer: | table | Correct Answer: | view | | | | | Question 2 4 out of 4 points | | | The person who designs, creates, and manages the database is theAnswer | | | | | Selected Answer: | DBA | Correct Answer: | DBA | | | | | Question 3 0 out of 4 points | | | Data consistency meansAnswer
Words: 780 - Pages: 4
What is the most popular type of database? relational Using a file-oriented approach to data and information, data is maintained in many separate files. 3. File-oriented approaches create problems for organizations because of multiple master files which may contain redundant data. 4. Which statement is true regarding file systems? The proliferation of master files creates problems in the consistency of specific data stored in different files. 5. A set of interrelated,
Words: 3223 - Pages: 13
existing tables. In other words, it uses the relationship of similar data to increase the speed and versatility of the database. Relationship database establish the relationships between entities by means of common fields included in a file, called a relation. For example, a customer orders a product. Each customer may has an ID number and has a name. The relationship between a customer and the customer’s order created by the
Words: 732 - Pages: 3
Top of Form Week 2: Tables, ER Modeling, and The DBMS - Discussion |Database Table Design (graded) | |When designing database tables, the difference between a good design and a bad design can be a few seconds in response time and | |several minutes. You may think that this is not a huge difference, but imagine waiting several minutes on a web page for your results | |to load. How
Words: 10657 - Pages: 43
Journal/diary 15/11/12 (1 hr) | Understanding the problem: * Half page introduction to scenario * Complete Preliminary investigation on marble bar | 16/11/12 (30 mins) | Understanding the problem: * Requirements report | 19/11/12 (1 hr) | Planning: * Feasibility study on flat file and relational database. * Economic and technical feasibility | 20/11/12 (1 hr) | Planning: * Schedule and organisational feasibility * Complete updated requirements report | 22/11/12 ( 1hr and
Words: 290 - Pages: 2
2014 Question 1 a. Why are tuples in a relation not ordered? b. Why are duplicate tuples not allowed in a relation? c. What is different between a key and a superkey d. Why do we designate one of candidate keys of a relation to be the primary key? e. Discuss the characteristics of relations that make them different from ordinary tables and files. f. Discuss the various reasons that lead to the occurrence of NULL values in relations g. Discuss the entity integrity and referential
Words: 313 - Pages: 2
I would start out by explaining to the customer what Microsoft Access is. Microsoft Access is software that manages databases. The database collects, organizes, and stores information about things. The second thing I would do is introduce some basic terms of Microsoft Access. A database table looks a lot like a spreadsheet. There are rows and columns like a spreadsheet, which makes it easier to convert a spreadsheet into a database. Each row and column in a table is referred to as a record
Words: 275 - Pages: 2
Advance Database Assessment – Marshalls Garage The problems with a flat file database are as follows -: The potential problems of a flat file database are mostly caused through duplication of the required information – e.g. each time the town is put in, it has to be typed separately, this can lead to errors with spelling and consistency e.g. (AE) instead of Dalbeattie, and also inconsistencies between the data whilst the information is being inserted into the database, this also leads to a
Words: 1010 - Pages: 5
(10 X 1.5=15) Answer all the questions 1.List out the function of computer. 2.List out any three Output device. 3.What is the Use of find command? 4.How to start the word.? 5.Define Zoom. 6.Write the sum formula. 7.Define Relation. 8.What you mean by Report? 9.What is the use of Undo? 10.What is the use of save as? Section-B (5 X 4=20) Answer all the questions 11.Explain about storage devices. (or) Discuss about operating system. 12.How to
Words: 1165 - Pages: 5
