...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 columns(fields).rows representing the complete information of individual items in a table are called records whereas columns representing a specific piece of information for all records are called fields. ii. Primary key is the name of the field or fields in a database table which uniquely identify each record in a table that is the value in this field/s are different for each record. For example, GR NO field in a student table is the primary key as it identifies each student uniquely in the table. iii. The steps are as follows 1. Click New button in the data base window to open New table dialog box and select the option table wizard or select Create table by using wizard to open Table Wizard dialog box. 2. Select Business or Personal depending upon the type of table. 3. Select the required table from sample table. The sample fields will appear. 4. To select field click >> button to select all the fields at a time or select...
Words: 336 - Pages: 2
...Applying Information Security and SDLC to Business Nusiaba Abbas, Jason Jernigan, Patrick Kein, & Natasha Scott BIS/320 October 8, 2012 Gordon Hodgson Barnes & Noble Who and what is the bookstore? What is their mission? Barnes & Noble offers a huge selection of textbooks, newspapers, magazines, music, DVD’s, and EBooks. They are the Internet’s largest bookstore offering an easy way for customers to find precisely what they are looking for in books. Barnes & Noble offers over 100,000 unique book titles per store and customers can walk into the store at anytime looking for titles not on the bookshelf. What products do they sell? The Largest book store of all is Barnes & Noble.com. This website ships faster than any other online bookseller. Barnes & Noble has dedicated time and money to meeting business objectives successfully. Books created to include audio books, MP3 audio books, award winners, and bargain books. To offer millions of books, EBooks, Nook tablets from a network of trusted sellers. All purchased at a convenient price that’s secure. Who are their customers? Barnes & Noble is the destination for book lovers offering an array of content. B & N studio offers hundreds of video author interviews, Emmy-winning documents and features a weekly book show. Anyone looking for best children’s books, videos, music, DVD, Blue ray stores makes it a great...
Words: 892 - Pages: 4
...Database Design Tyrone Thompson DBM380 November 28, 2010 Kurt Jost A database is a table-based tool offering an organized mechanism to store, manage, and retrieve information. Relational data becomes a powerful business tool when queried for desired information by users and relationships established between other pieces of data. A variety of different types of databases are available, some more common than others. The database administrator’s task is to choose the database type that will best work with the data provided. A database system consists of four components: database, a database management system, database application, and users. At my workplace various databases are in use. At Omega Engineering for three decades its handbooks have served as valuable reference tools for engineers around the world. Though it is an established direct-marketing pioneer, the people, facilities and superior client services go well beyond the original Omega handbooks and have progressed into a highly automated, online data warehouse accessed via its website www.omega.com. Omega's world-famous product handbooks and encyclopedias, online as well as in print, feature hundreds of thousands of products, technical tips, topical articles, reference charts and graphs, and some of the largest, most detailed product images in the industry. A document-oriented database layers other database systems, for example, a relational database. Structured query language (SQL) server databases are used...
Words: 840 - Pages: 4
... Page 19 Conclusion Page 20 Bibliography Page 21 Introduction In the following assignment I will present an introduction to databases which will demonstrate my knowledge through creating reports, defining key terms and there advantages and disadvantages, as well as designing an entity model. These will support my knowledge. TASK 1 Diagram 1: Marks & Spencer’s three-layer relational database architecture related to their online activities. Internal Schema (Server) Conceptual Schema (Programmer) External (Customer) External (Supplier) External (Business partners) External (Departments) As shown in diagram 1, a 3-layer Relational database separates the physical database from the user applications. The following schemas are defined at each of the following levels: * Internal * Conceptual * External “The DBMS is responsible for mapping between these...
Words: 2877 - Pages: 12
...Accessing the Oracle Server Adewale Sonubi Professor Brian Smith CIS 111: Introduction to Database Management System October 13, 2013 Through this assignment, I was able to experience logging into the Strayer University Oracle Server. The process started a little rough for me because I did not have the necessary credentials, but once I received them from I was able to log in. the screen I attained at the end of the exercise is shown below: I googled putty on the google search engine and found www.putty.org; I was able to save the download on my desktop for future use. One I opened it, I entered “unix-online.strayer.edu” in the host section using port 22. I also entered “Student UNIX Server” I the saved session and saved it also for future use. After entering both required information, I clicked “OPEN” and the command screen opened. I was prompted for a login and password of which I entered the information provided to me by the professor and I was able to log into the UNIX server. I also typed in the oracle command provided to me and I was able to log into the oracle server. I made sure I tried the process more than once to ensure I properly understand the process. After finishing the exercise, I searched for the snipping tool on my desktop, and was able to take a snapshot of the screen and save to my desktop. I then copied and pasted the screen into this document to show that the assignment was done and that my credentials...
Words: 276 - Pages: 2
...Lovely Professional University Case study on student record keeping system Name Abhishek Bhatt Regd. No. 11109390 Roll No. A21 Section K1104 Submittked By Submitted to Abhishek Bhatt Vipin Kumar Case Study case study on student record keeping system Table Of Content 1) Introduction 2) What is DBMS ? 3) Features/Advantages of DBMS. 4)Disadvantages of DBMS 5)Advantages of student record keeping system 6)Note * Introduction : * DBMS : DBMS Stands for Data Base Management System. It consists of interrelated data and set of programs to access those data. * Data : Raw information is called data. * Database : Database is a collection of interrelated data, contain information about one particular enterprise. * Interrelated Data : It is a type of data which is related to each other. e.g. Student and subject, parents and child. * About My Topic : My topic is about case study on student record keeping system * Introduction to case student record keeping system Student Record Keeping System is a comprehensive solution for all of a school’s student management needs, like enrollment...
Words: 1384 - Pages: 6
... | |Airline Reservation System | |ITEC 630 | |Fall 2008 | | | |11/15/2008 | North Central Airlines Airline Reservation System Proposal Phase 1 Background (Problem Statement): North Central Airlines is a small but growing airline that specializes in providing amenities that major airlines don’t (like children discounts, for example). The corporate executives feel that the Global Distribution System that they currently use and share with larger airlines doesn’t provide the extra services that North Central needs for their business to thrive. Their intent is to design and construct their own Airline Ticketing System. Originally, the two options for this systems was to use a COTS from a respected vendor, or to design an Object Oriented System that was constructed and built entirely by the staff at North Central. North Central...
Words: 2728 - Pages: 11
...Database in the Workplace Angela Davis-Delgado CIS205 02-11-2011 Dr. Lopez Abstract Databases are critical to today’s business. America needs to be sure that its stored information is secure. The days when personal computers were used as a storage device are gone. Today companies have networks composed of servers capable of storing millions of bits of data on their systems. Companies must be able to understand database fundamentals when they decide what database systems they need. When a company obtains data, it must be organized in a readable format so that company personnel can access it from their computers, as it is needed. Databases have become very common in the workplace today. Many organizations use databases to keep track of payroll, vacation time, supply inventories, and other information and for many other tasks too numerous to include in this abstract. Business use database anytime they have large amounts of data they need to search and categorized, so that it can be access later for other uses. In designing and determining the purpose of a database there are two key principles, which need to be considered. The first is duplication of information and the second is the correctness or quality of that information. Duplicate information must be minimized or avoided because it wastes space, increases errors and creates inconsistencies. The second principle, correctness, involves making sure data is entered correctly otherwise any queries and reports...
Words: 821 - Pages: 4
...points program (Kudler Fine Foods, 2009). Kudler’s partnership with a loyalty points program will provide customers with a points program where the customer can redeem points for high-end gift items, specialty foods and first-class airline upgrades (Kudler Fine Foods, 2009). Team A has been invited to create a business/systems requirement document to initiate the development of the Frequent Shopper Program. Team A will outline in the following document Team A’s proposed plan in meeting the objective of the aforementioned request. Executive Summary ------------------------------------------------- Kathy Kudler’s vision became a reality in 1998 when she opened her first store in La Jolla, California. Gourmet cooking coupled with efficient food preparation was the cornerstone of the La Jolla store (Apollo, 2008). Kudler’s has expanded with the opening of the Del Mar location and with Kudler’s latest store, which opened in 2003 at Encinitas (Kudler Fine Foods, 2009). Presently, Kudler Fine Foods track information such as dollar value and profit per transaction. A more intimate client relationship is needed for the expansion of Kudler Fine Foods. Integrating a system that will track customer purchase behavior over time will allow for a more intimate view of clients most valued products....
Words: 1257 - Pages: 6
...Critical Information System Paper Ted Ko, BSA 310 University of Phoenix August 21, 2011 Greg Walker Critical Information System Kudler Fine Foods is a local gourmet grocery store located in San Diego, with three locations. All the stores carry the very best domestic and imported goods. Kathy Kudler, Owner of Kudler Fine Foods, opened the first of three stores in 1998. In the year 2000, Kathy opened a second store with the third store opening in 2003 (Kudler Virtual Organization, 2006). Kudler Fine Foods utilizes an information technology system that is vital to its business. The company uses the POS (Point of Sales) Database System to organize and keep track of items and orders. Without this, they would not be as successful as they are. Point of Sales System Databases keeps track of inventory, supplier, order, customer, store, tender (sales), tax table, order line, and item. A successful business cannot function accurately without all these tables. The Inventory Table contains the components that make up an item. Such as, perishable indicator, quantity on hand, and unit cost. It is also “used for managing inventory and determining the availability of ingredients that go into prepared items, such as bakery products, ect” (Kudler Virtual Organization, 2006). “The Supplier Table data concerning wholesalers, vendors and other suppliers from whom inventory is procured” (Kudler Virtual Organization, 2006). Meaning, depending on the inventory, which is going to determine who...
Words: 546 - Pages: 3
...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, centrally coordinated files is called a database. 6. The software program that creates, manipulates, and accesses the database goes by the acronym DBMS. 7. The ___________ acts as an interface between the database and the various application programs c) Database management system 8. The combination of the database, the DBMS, and the application programs that access the database through the DBMS is referred to as the c) Database system 9. The person responsible for the database is the b) Database administrator 10. All of the following are benefits of database technology except: b) Decentralized management of data 11. Separating the logical and physical views in a database allows the programmers to concentrate on coding the application logic b) since they do not have to focus on the physical location and layouts of various data items. 12. A database system separates the logical and physical view of data. Such separation facilitates the development...
Words: 3223 - Pages: 13
...A relational database solution or relational databases have helped many companies gain more information about their operations by supporting simple operator queries, answering questions such as "What customer had the largest demand?" of "What customer ordered the largest shipment?" They are built to manage relationships and are ideal for starting contextual or genealogical information about processes. Before I continue I would like to explain what a relational database is and what it is derived from. Databases have been a staple of business computing from the very beginning of the digital era. In fact, the relational database was born in 1970 when E.F. Codd, a researcher at IBM, wrote a paper outlining the process. A database is an application that can store and retrieve data very rapidly. The relational bit refers to how the data is stored in the database and how it is organized. Since then, relational databases have grown in popularity to become the standard. A relational database allows you to easily find specific information. It also allows you to sort based on any field and generate reports that contain only certain fields from each record. Relational databases use tables to store information. With a relational database, you can quickly compare information because of the arrangement of data in columns. The relational database model takes advantage of this uniformity to build completely new tables out of required information from existing tables. In other words, it uses...
Words: 732 - Pages: 3
...DMB/380 February 10th 2014 DMB/380 February 10th 2014 Art Museum Database By: For the past couple of years, a local art Museum has been collecting different art pieces from various artists. The Museum then displays the art throughout different galleries across town. The collection has significantly grown and it is now complicated for the museum to keep track of the many different artist and their different art pieces and collections, as well as where the art is located, whether it is stored in different galleries or the Museum itself. It is important for the Museum to develop a database that can keep track of the different art pieces, the artists, the different locations the pieces can be located and a total amount of pieces collected since it continues to grow at a very fast rate. The database will help the Museum substantially as well as the artists who create many various art pieces. Problems and Constraints The Museum continues to grow and it has become difficult for the manager and staff to keep track of the art collection. Not having a database that can tie the artist with his art and the location of it has caused the Museum to lose some of the different art pieces which in return equal financial losses to the Museum. Another problem the Museum continues to have is keeping track of when and where the art is being displayed. Most of the art is displayed for a period of time throughout the different galleries then either stored back...
Words: 1015 - Pages: 5
...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 long would you wait? A slow database can mean the loss of customers. So let's begin by discussing some of the common | |elements of tables and how you would approach the table design. What would you do to ensure that your page loads in a few seconds? | |Discuss the relationship types and how they affect your design. | |Responses | |[pic|[pic|Response |Author |Date/Time | |] |] | | | | | | |[pic] ...
Words: 10657 - Pages: 43
...------------------------------------------------- 1. Explain the main difference between a file-oriented system and a database system. A file-oriented system utilizes data in a regular OS file based format where a database system uses a database engine that organizes data in a database in a table format utilizing rows for each record. 2. What is a DBMS? Briefly describe the components of a DBMS. DBMS stands for Database Management System. A DBMS is a collection of tools, features, and interfaces that enables users to add, update, manage, access, and analyze the contents of a database. A DBMS is made up of a DML (data manipulation language), Schema and subschemas, Physical data repository, and an Interface to allow access to the database from DBA’s, Users, and Related Information Systems. 3. Describe a primary key, candidate key, secondary key, foreign key, and common field. Primary Key – a field or combination of fields that uniquely and minimally identifies an entity. Candidate Key – Any field or combination of fields that can act as the primary key but are not. Secondary Key – Any field of combination of fields that can be use to identify a entity. Foreign Key – A field that exists in an entity that is the PK of another entity. Common Field – An attribute (field) that appears in more than one entity (record). 4. What are entity-relationship diagrams and how are they used? What symbol is used to represent and entity in an ERD? What symbol...
Words: 1096 - Pages: 5
