...1) A… CREATE VIEW TopLevelCust AS SELECT CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit FROM Customer WHERE CreditLimit >=10000 ; B… SELECT CustomerNum, CustomerName FROM TopLevelCust WHERE Balance>10000 AND CreditLimit>=10000 ; C… SELECT Customer.CustomerNum, Customer.CustomerName, Customer.Street, Customer.City, Customer.State, Customer.Zip, Customer.Balance, Customer.CreditLimit FROM Customer WHERE (((Customer.Balance)>10000) AND ((Customer.CreditLimit)>=10000)); 2) A… CREATE VIEW PartOrder AS SELECT PartNum, Description, Price, OrderNum, OrderDate, NumOrdered, QuotedPrice FROM Part ; B… CREATE VIEW TopLevelCust AS SELECT PartNum, Description, OrderNum, QuotedPrice FROM Part WHERE QuotedPrice>100 ; C… SELECT Part.PartNum, Part.Description, Part.Price, Orders.OrderNum, Orders.OrderDate, OrderLine.NumOrdered, OrderLine.QuotedPrice FROM Part INNER JOIN (Orders INNER JOIN OrderLine ON Orders.OrderNum = OrderLine.OrderNum) ON Part.PartNum = OrderLine.PartNum WHERE (((OrderLine.QuotedPrice)>100)); 3) CREATE VIEW OrdTot AS SELECT OrderNum, NumOrdered*QuotedPrice AS OrderTotal INTO OrdTot FROM OrderLine; 4) A… CREATE INDEX PartIndex1 ON OrderLine(PartNum); B… CREATE INDEX PartIndex2 ON Part(Warehouse); C… CREATE INDEX PartIndex3 ON Part(Warehouse, Class); D… CREATE INDEX PartIndex4 ON Part(Warehouse, OnHand DESC); 5) DROP INDEX PartIndex3; 6) CHECK (Class IN (SG, HW, AP)) FOREIGN KEY...
Words: 340 - Pages: 2
...When you purchase a products online like a DVD the company you purchase through invoices D & G Inc. and we ship the product via UPS to you. At D & G Inc. the Hardware we use a basic Dell Computers running Windows XP. We have about thirty computers in the warehouse and offices. We use Telzall scanning devices to scan and keep track of all merchandise in the warehouse. Without the proper hardware and software tools, the job of keeping track of tens of thousands of products would be a much more time consuming, and need many more employees to accomplish correctly . Hardware and Software The software we use here at D & G Inc. is the most important part of smooth operations. The software we use was created for us at D & G Inc. The system is called SMART it connects all of our databases together. The SMART system makes easy access to any database through, one of the dell computers or through the handheld Telzall scanners. The SMART system runs the time clocks to keep track of all employee hours. First you scan in your ID badge in to the time clock provided on the wall next to all exits. Once you are scanned in to the SMART system you are allowed to log in to the database and access information you need to preform your job duties. The sales department uses the Dell computers to access the internet to receive emails from the online stores of what products have been ordered then interred into the customer database and the invoice sales database . That is where we...
Words: 708 - Pages: 3
...Database Systems name 3-12-2012 Web-407 Advanced Web Development instructor's name Introduction Most companies need some type of database. A company may be small or extremely large but they all share one thing in common, if they make any type of product, sell anything, keep contacts, balance the books, pretty much anything a business can any will do, they need some type of database or multiple databases to store and later retrieve the data a typical business generates. Choosing the right database is even more important in the age of the Internet, products and services can be sold around the world now and the data from shopping carts and other payment and shipping needs a database too. This article will go into a bit more detail on some of the types of databases that are available and how to pick the right one for your company. Open Source vs. Proprietary This is the big question on a lot of businesses minds these days. Rather to try and cut costs by integrating an Open Source database or a proprietary one. First off let us go over what open source means. Open source software, in this case a database, is software that generally has a limited license for free using. The software is developed and maintained by developers and coders around the world that continuously work at improving the software but providing security upgrades and bug fixes. Proprietary software on the other hand is generally developed, upgraded and patched by a company that sells or licenses the software...
Words: 1313 - Pages: 6
...Amazon Address the uses of the Amazon.com® database; possible data management issues; and the relationship amongst Amazon®’s data, information, and knowledge. Amazon is a one of the most amazing Internet sellers of used and new books that have been competitive with Borders. Amazon.com gives and present discounted books at different prices, but with true understanding of the seller and customer. The one company to have the largest product information databases in the world is Amazon. Amazon database contains more than thousands of customers, sellers, products and orders, which can be in the millions. The data of Amazon contains data information of payment transactions and type, browsing histories, and referrers. Most of the products that Amazon contains would be the price information from sellers, review, and the ranking. Customers and consumers uses the database of Amazon to read reviews to exam products, compare prices and use research tools to purchase products from the website. Issues with Amazon can occur with data management issue with using different versions of the product (Milliot 2003). . I notice that Amazon does give he or she a chance to review books online before making a purchase and also allow them to read reviews. Amazon sells various editions of books from textbooks to novels. Amazon’s data are the effects of any transactions in inventory, sale transactions, and information about the seller and about the buyer. Most consumers compare Ebay and...
Words: 321 - Pages: 2
...CHAPTER 6 Introduction to SQL LEARNING OBJECTIVES After studying this chapter, you should be able to: ■ Concisely define each of the following key terms: relational DBMS (RDBMS), catalog, schema, data definition language (DDL), data manipulation language (DML), data control language (DCL), scalar aggregate, vector aggregate, base table, virtual table, dynamic view, and materialized view. ■ ■ ■ ■ ■ Visit www.pearsonhighered.com/ hoffer to view the accompanying video for this chapter. Interpret the history and role of SQL in database development. Define a database using the SQL data definition language. Write single-table queries using SQL commands. Establish referential integrity using SQL. Discuss the SQL:1999 and SQL:2008 standards. INTRODUCTION Pronounced “S-Q-L” by some and “sequel” by others, SQL has become the de facto standard language for creating and querying relational databases. (Can the next standard be the sequel to SQL?) The primary purpose of this chapter is to introduce SQL, the most common language for relational systems. It has been accepted as a U.S. standard by the American National Standards Institute (ANSI) and is a Federal Information Processing Standard (FIPS). It is also an international standard recognized by the International Organization for Standardization (ISO). ANSI has accredited the International Committee for Information Technology Standards (INCITS) as a standards development organization; INCITS is working on the next version...
Words: 22483 - Pages: 90
...consideration in HRIS Strayer University Dr. Sue Golabek January 25, 2015 Use the internet to research and evaluate two (2) commercial systems for your organization. Evaluate the advantages and disadvantages of each system and, based on your knowledge of human resources and database systems, propose one (1) package that would fit the needs of your organization. Suggest three (3) specific reasons why you would recommend that system over the other. The benefits of utilizing a database are substantial. In today’s revolutionary business world, it is hard to imagine a company not desiring to invest in a Software that can manage information, and offer a level of security with password protection for wondering eyes (Thomas, 2013). The advantages of a business to use Peachtree Software are rapid access to information, trouble-free reporting, good organization, and many other features. Peachtree Software is written in Microsoft Access, without problems that can rapidly track employee’s attendance, evaluations, payroll, customers’ data, training, and applicants’ data, as well as making sure the company is well informed about any changes in government regulation (HR data manager, 2013). Another database system would be Oracle PeopleSoft that offers compensation, recruiting solutions, payroll interface, time and labor record keeping, travel and expense, and general ledger/budgeting report, which is beneficial to any organization (Oracle. para 4, 2006). However, there are some disadvantages...
Words: 1309 - Pages: 6
...DATABASE A database is an organized collection of data. The data are typically organized to model aspects of reality in a way that supports processes requiring information. For example, modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies. Database management systems (DBMSs) are computer software applications that interact with the user, other applications, and the database itself to capture and analyze data. A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases. Well-known DBMSs include MySQL, PostgreSQL,Microsoft SQL Server, Oracle, SAP and IBM DB2. A database is not generally portable across different DBMSs, but different DBMSs can interoperate by using standards such asSQL and ODBC or JDBC to allow a single application to work with more than one DBMS. Database management systems are often classified according to the database modelthat they support; the most popular database systems since the 1980s have all supported the relational model as represented by the SQL language. Sometims a DBMS is loosely referred to as a "database". database is a collection of information that is organized so that it can easily be accessed, managed, and updated. In one view, databases can be classified according to types of content: bibliographic, full-text, numeric, and images. In computing, databases are sometimes classified according to their organizational approach. The most...
Words: 4833 - Pages: 20
...customer and complete relationship diagram of the system is represented with all the tables’ relationship and cardinality description. This is complete system database design that is followed through the help of information about Island Dream. b. Normalization: Normalization of each part in the scenario contributes making the data integrity because it reduces redundancy of data and also data negligence. To evade redundancies and anomalies in these tables, they are reduced to a 3rd normal form, by decomposing existing tables or adding new tables. In the end we have suggested some ways to use codes for these tables to simplify...
Words: 1131 - Pages: 5
...modeling is extremely valuable in a complex data environment. In relational database management system, entity relationship modeling becomes essential when dealing with a large number of entities and/or complex relationships. In addition, some entities that have many different relationships, or even multiple relationships with a single entity, can be difficult to conceptualize without the assistance of a well-thought-out model. As pointed out by Allen (2005), entity relationship modeling provides a highly intuitive reference for developers of a database system. ACME Global Consulting is an organization that services a vast number of clients across many domains. They deal with thousands of orders and products on a daily basis. From their customer service department to their order fulfillment department, the need for an efficient, accurate information system is self-evident. However, when dealing with so much information in such a complex system, the importance of proper planning and design cannot be overstated. There is no area of the system development lifecycle more critical than planning and design. The purpose of the entity relationship model to be developed for ACME Global Consulting is to visualize the entities and relationships that will exist within the relational database. As is discussed by Chilton (2006), it can be difficult to wrap one’s mind around the concept of relational databases at first. It really is not that difficult. It is exactly what it sounds like...
Words: 953 - Pages: 4
...Examples of database and table creation The following examples use the create keyword to create the sample staff database and define the tables. These example OQL statements illustrate the use of the column constraints and the default keyword. Example 1 create database staff; // creates the staff database The following insert defines the managers table. create table staff.managers ( EmployeeID int NOT NULL PRIMARY KEY, Name text NOT NULL, Department text default "Sales", Gender text, Age int, unique ( EmployeeID ) // indicates that the data in the // EmployeeID column must be unique. ); For the managers table: • The EmployeeID and Name columns cannot be NULL. • The EmployeeID column is the primary key and must be unique. • If no value is inserted into the Department column for a given record it takes the value "Sales". Example 2 The following insert creates the staff.employees table. create table staff.employees ( EmployeeID int NOT NULL PRIMARY KEY, Name text NOT NULL, Skills list type text, Gender text, Age int // There is no comma here because this ...
Words: 978 - Pages: 4
...activitymode.com/product/nurs-439-discussion-question-week-2/ Contact us at: SUPPORT@ACTIVITYMODE.COM NURS 439 DISCUSSION QUESTION WEEK 2 One of the most challenging aspects once your PICOT question is developed is to conduct an effective search of the literature to be certain you have not missed important sources of information. I know I have been challenged in the past with being certain I had investigated all potential sources of evidence. For example, many times, I am researching educational literature and I often find that I can locate information from a variety of sources including nursing databases (Cinahl). One of the most helpful things I have found to do is when I am conducting a search is to look in the reference list for the articles I am choosing to discover if I am missing an important article or book from a source I haven’t explored yet. I look forward to learning about the challenges you faced in your literature search and how you overcame those challenges. I can assure you that we will all learn a lot from this discussion. The Course Outcomes (COs) we will apply in Unit 3 include: • Examine the sources of evidence that contribute to professional nursing practice. • Apply research principles to the interpretation of the content of published research studies. Review the guidelines, grading rubric, and brief video (link found in guidelines) that explain the Research Database Assignment due in Week 4. Search for one research database that is relevant...
Words: 1006 - Pages: 5
...business, an organized collection of relevant data is a critical element to a firm’s success. No matter what form of business one is involved in - whether it be a sole proprietorship, partnership, or corporation - having at least one quality database is a must if he or she expects favourable results. With effective and efficient databases, companies are able to deliver great service or produce the required units of merchandise on a timely manner. It is an established fact that running a business is no easy feat. This is especially true for a relatively new one, which is still struggling to make a name for itself while trying to generate more capital for its operations. Because of the sheer number of challenges an emerging proprietor faces, he or she needs as much help as he/she can have when it comes to managing his/her business. Databases provide great help for this very problem. Listed below are the several purposes databases generally try to serve to a typical business: * It helps organize important information – information is a key factor to any business, and having systematically arranged records help the user know what needs to be done, how it must be done, and who it is being done for. * It helps save time – with a database, instead of spending precious time going through piles of papers just to search for the necessary information, the user is just a query away from retrieving what is needed. * It aids the communication among employees – due to the different...
Words: 489 - Pages: 2
...Review Questions 1. What are the problems of managing data resources in a traditional file environment and how are they solved by a database management system? List and describe each of the components in the data hierarchy. Figure 6–1 shows the data hierarchy. The data hierarchy includes bits, bytes, fields, records, files, and databases. Data are organized in a hierarchy that starts with the bit, which is represented by either a 0 (off) or a 1 (on). Bits can be grouped to form a byte to represent one character, number, or symbol. Bytes can be grouped to form a field, such as a name or date, and related fields can be grouped to form a record. Related records can be collected to form files, and related files can be organized into a database. Define and explain the significance of entities, attributes, and key fields. • Entity is a person, place, thing, or event on which information can be obtained. • Attribute is a piece of information describing a particular entity. • Key field is a field in a record that uniquely identifies instances of that unique record so that it can be retrieved, updated, or sorted. For example, a person’s name cannot be a key because there can be another person with the same name, whereas a social security number is unique. Also a product name may not be unique but a product number can be designed to be unique. List and describe the problems of the traditional file environment. Problems with the traditional file environment include...
Words: 1013 - Pages: 5
...Relational Database Management Systems TVSN Murthy Assistant Professor – DFT NIFT Hyderabad Disclaimer: These slides are just for the purpose of easy reading and are not comprehensive in nature. Thus the slides have to be read together with the class lectures, reading material, and statutes dealing with the subject RDBMS/Slide 1 Introduction Flat files - 1960s - 1980s Hierarchical – 1970s - 1990s Network – 1970s - 1990s Relational – 1980s – present Object-oriented – 1990s – present Object-relational – 1990s – present Data warehousing – 1980s – present Web-enabled – 1990s - present RDBMS/Slide 2 1 Introduction Data Models Classification Data models can be classified as: 1. 2. 3. File-based systems Traditional Data Models Semantic Data Models File-based Systems: Entities or objects of interest are represented by records that are stored together in files. Relationships between objects are represented by using directories of various kinds. RDBMS/Slide 3 Introduction Data Models Classification Traditional Data Models: Traditional data models are the Hierarchical, Network and Relational Models. Hierarchical Model:- Evolved from the file based system Network Model:- Is a superset of the Hierarchical model. Relational Model:- Is based on the mathematical concept of relation. Semantic Data Models: This class of data models was influenced by the semantic networks developed by artificial intelligence researchers. Semantic networks were developed to...
Words: 4443 - Pages: 18
...CS251-1301B-03 Fundamentals of Database Systems Phase 1 -5 Individual Project Robert March 24th, 2013 Table of Contents Project Outline 3 Description of the Database Design Life Cycle 4 The Entity Relationship Diagram 7 The Logical Model and Normalization 9 The Microsoft Access Database 11 The Microsoft Access Database Application 14 References: 18 Project Outline My idea for a project concept is for a granite fabrication and installation company called MasterStoneWorks. We will perform counter sales, contractor and walk-in customer kitchen and bath design, templates, fabrication, installation, and follow-up. To run efficiently (or at all) we must have a centralized DBMS with access for all employees in order to keep track of the progress of the workload and get the products delivered and installed on time. Issues with the process must be immediately known and corrected as this is a high value product with a small profit margin at this point in our economy. Any miscommunication can be disastrous. The MasterStoneWorks database will have the following tables: * Customers * Sales * Installs * Product choices * Costs (wholesale and retail) * Sales people * Project Managers * Templates * Follow-up * Customer support Description of the Database Design Life Cycle The seven steps of the SDLC/DBDSL: 1. Concept Planning – This first step is where the need to develop, or improve a system is ascertained...
Words: 1691 - Pages: 7
