Premium Essay

Database Concepts

In: Computers and Technology

Submitted By mdowney25
Words 2823
Pages 12
Assignment 2

Task 1
OrderItem
Items
Orders
Reps
Customers

Has many

Can be ordered
Can place
Can contain

Can be stored

ItemLocation
WarehouseLocations

Can store

Domain Name | Meaning | Domain Definition | ID | Representative Number, Customer Number, Order Number, Item Number, Warehouse Number | Alphanumeric Size 10 | Name | Customer Reps Lastname, Firstname; Customers Lastname, Firstname | Character Size 20 | Address | House Nmuber \ Name, Warhouse Number \ Name, Street, City, County | Aphanumeric Size 20 | Post Code | Post Code | Alphanumeric Size 8 | Telephone Number | Cust Rep Telephone Number; Cust Telephone Number; Warehouse Telephone Number. | Numeric Size 15 | Date | Date of Order, Date Joined | Date | Goods | Number in Stock, Product Category, Item Description | Alphanumeric Size 20 | Order | Amount Paid, Unit Price, Quantity Ordered, Balance Outstanding, Commision Rate | Numeric Size (8,2) |

Reps Rep_ID | ID | Required | Primary Key | LastName | Name | Required | | FirstName | Name | Required | | AddressID | Address | Required | | StreetName | Address | Required | | City | Address | | | County | Address | | | PostCode | Post Code | Required | | TelNo | Tel | Required | | CommisionRate | Numeric | Required | |

Customers Cust_ID | ID | Required | Primary Key | Rep_ID | ID | Required | Foreign Key Reference Reps – Reps_ID | LastName | Name | Required | | FirstName | Name | Required | | AddressID | Address | Required | | Street | Address | Required | | City | Address | | | County | Address | | | PostCode | Post Code | Required | | TelNo | Tel | Required | | Balance | Numeric | Required | |

Orders…...

Similar Documents

Premium Essay

Database Concepts

...Database Concepts David Emersion DBM380 6/29/2015 Wade Fergus Database Concepts In an age when information is power, each business in the market place must make use of every tool at its disposal. Efficiency is the hallmark of any successful business. For a business to be efficient it must be the master of managing its own information. Time is money, and using an ineffective information management system is simply money down the drain. Quick access to accurate information is crucial to an organization’s success. Fortunately, businesses have a powerful weapon at their disposal – databases. Database Systems Every organization from small non-profit teams up to huge corporations supporting millions of customers must keep records of different types of data. These data can vary from inventory prices, to payroll, to medical records, and everything in between. The common challenges that these organizations face is keeping the data accurate, relatively easy to use, and secure. The solution to this problem is to use a database that fits the needs of the organization. A database is a system that houses data and metadata. Metadata is the information about the data and includes “information such as the name of each data element, the type of values (numeric, dates, or text) stored on each data element, and whether the data element can be left empty” (Coronel, Morris, & Rob, 2013, p. 7). A database system......

Words: 578 - Pages: 3

Premium Essay

Database Concepts

...Database Systems DBM/380 July 13, 2015 James Cervi Database Systems When it is necessary to store and manage data, a database is used. A database is a collection of data organized in such a way that it can be easily stored, managed, and manipulated. “You can think of a database as an electronic filing system” (QuinStreet Inc, 2015). It is safe to assume that a large percentage of organizations use databases for managing the wide array of data within their company. Databases can keep track of data such as: employee records, consumer demographic and contact information, and company files. A database management system (DBMS) is the software that controls the movement of data in and out of the database, as well as within the database. While a database management system refers to the software used to control the data, the database refers to the body of data being stored. Types of databases can be classified in numerous ways. They can be classified by the user, such as: desktop database meant for a single user, or a work-group database meant for multi-users. There is also an enterprise database which is used by an entire organization. Databases can be categorized by location. A centralized database manages data at a single site, whereas a distributed database manages data in multiple locations. Another way of categorizing databases is by the type of data that is being stored. “General-purpose databases contain a wide variety of data used in multiple disciplines” (Coronel,...

Words: 913 - Pages: 4

Free Essay

Database Concepts

...Mary Easterling Database Concepts Paper (Ch. 30 Web Technologies and DBMS) The internet or web was created in 1989, the internet grew into the powerful information exchange service that it is today. It has expanded the world at a pace that has astounded many experts in this new field. This new technology brought forth many new ideas for better, faster, easier ways to communication between the different computer formats, so the experts had get together and create a universal language that would be accepted with all computer hardware systems. Most web pages today are written in HTML, XML, JAVA, JavaScript are just a few examples. Websites now and in the past use the uniform resource locations (URL’s) to communicate inside the different browsers with the information or resources on a specific server. Without these locations, the information cannot be found or accessed, for example, to access Google.com, the browser needs to break down the information into an address to continue, and if the address is incorrect or cannot be located it will return a page not found error. Hypertext markup language (HTML) is the most common language that spans across the different platforms. This language is pretty easy to learn using the free basic instructions available on the internet, and now most high schools teach HTML to their students so they can create their own webpage. Most personal webpages today are a great example of what is called a static web page. “An HTML document that......

Words: 517 - Pages: 3

Premium Essay

Database Management Concepts

...DATABASE MANAGEMENT CONCEPTS 1. The DBA asks for your help in planning the data archive for the following Premiere Products database:     Rep (RepNum, LastName, FirstName, Street, City, State, Zip, Commission, Rate)     Customer (CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit, RepNum)     Orders (OrderNum, OrderDate, CustomerNum)     OrderLine (OrderNum, PartNum, NumOrdered, QuotedPrice)     Part (PartNum, Description, OnHand, Class, Warehouse, Price) Determine which data from the database to archive; that is, for each table, specify whether data needs to be archived. If it does, specify which data, when it should be archived, and whether it should be archived with data from another table. 2. The DBA denormalized some of the data in the Premiere Products database to improve performance, and one of the resulting tables is the following: Customer (CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit, RepNum, RepName) Which field or fields cause the table to no longer be in third normal form? In which normal form is the denormalized table? 3. Does your school have a formal disaster recovery plan? If it does, describe the general steps in the plan. If it does not, describe the informal steps that would be taken if a disaster occurred. For the following exercises, you will answer problems and questions from management at Premiere Products. You do not use the Premiere Products database for any of these......

Words: 471 - Pages: 2

Premium Essay

Dbm 380 - Database Concepts

...DBM 380 FULL COURSE http://www.learnyourcourse.com/dbm-380/98-dbm-380-full-course.html DBM 380 WEEK 1 DBM 380 Week 1 DQ # 1- Based on the Manegold (2009) article, describe one method of optimizing data retrieval from a high-use database. (There are many such methods mentioned in the article - pick one you like and do a deep dive.) DBM 380 Week 1 DQ # 2- In the course text, there is some discussion of the capabilities of databases, and recognition of these as an evolution beyond file-based storage approaches. Spreadsheets are one example of a file-based approach. What kinds of things can database management systems do that spreadsheets can't? Also, why is it that in spite of the many apparent data management advantages of databases, spreadsheets are frequently used for data storage in all kinds of organizations? DBM 380 WEEK 2 DBM 380 Week 2 Individual Assignment - Database Design Paper DBM 380 Week 2 DQ # 1- Using the Geiger (2009) article as a guide, how must a database administrator balance the time to complete data modeling step with the benefits this step offers in creating a database? DBM 380 Week 2 DQ # 2- What are the issues identified in the Cox (2009) article that a database administrator should know when working with a many-to-many relationship? Identify and discuss one of these issues. DBM 380 WEEK 3 DBM 380 Week 3 Individual Assignment - ERD Creation Project DBM 380 Week 3 DQ # 1- Why do you think the use of icons in entity-relationship diagrams as......

Words: 481 - Pages: 2

Free Essay

Database Concepts Research Paper

...Database concepts research assignment week 9 Don't use Personal Identifiable Information (PII) in your password such as, Name, User name, Birthday, Pet’s name or Child's name. Don't use any word that can be found in the dictionary as your full password. Don’t use the same password for online banking that you use for social networking or email. Don’t give your password to someone over the phone. Try to use special characters such as non-alphabetic characters. Try to create passwords at with at least eight characters. Try to use a password vault application to protect and help manage your many passwords. Try to change your most critical passwords on a regular basis. The Windows operating system already has authentication functionality built-in. It has to do so. And if you're in a domain environment, there are special computers, called Domain Controllers, where authentication actually takes place. Those systems tend to be treated more security than regular servers, even SQL Servers. And therefore, if the username/password combinations are going to be stored on the most secure systems in the domain, that would be on the domain controllers (as a side note, a hash is what is actually stored there, not the password itself). If you let Windows do the authentication, then SQL Server doesn't have to store anything related to a username/password combination. And it's up to Windows to check the security. In other words, SQL Server is handing off this sort of authentication to processes......

Words: 729 - Pages: 3

Free Essay

Executive Summary for Relational Database Concepts

...organization endeavors to improve almost daily. Most important is the data cleaning and data transformation processes. In actual sense, relational database offers a solution to this menace. Data organization, keeping, storage, and retrieval among other essentials can easily be realized by adopting relational data management model. In this kind of model, tables are made use of in such a way that data items are formally described and organized according to their level of relations. The data item contained in a given table represents a relation. I am convinced beyond reasonable doubt that through the use of relational database model, an organization can be able to effectively manage their wide range of information encountered on a daily basis. Relational database model offers a more efficient means of managing data. Some of the huge benefits are discussed as follows. WHY RELATIONAL DATABASE MODEL?          This model is very unique and provides very sufficient means of data management. Its benefits are manifested in diverse ways which among others are its ability to enable you to store, manage, and retrieve your data in a flexible manner while maintaining vital data veracity. This is just but a tip of the ice berg (R. Snow, 2008). Accessing and transforming data           Nowadays, the relational database models available are so powerful that they allow you an access to a query that easily transforms and retrieve data. This is actually a big......

Words: 649 - Pages: 3

Premium Essay

Database Normalization and Logical Process Concept Paper

...Database Normalization and Logical Process Concept paper This short paper will explain with a simple example the process and the need of normalization in the most of the business databases. Complete proposal break down (Timeline phases, Financial phases) will be submitted per management request. Overview At first any database should be designed with the end user in mind. Logical database design, also referred to as the logical model, is the process of arranging data into logical, organized groups of objects that can easily be maintained. The logical design of a database should reduce data repetition or go so far as to completely eliminate it. The needs of the end user should be one of the top considerations when designing a database. We should remember trough all design process that the end user is the person who ultimately uses the database. There should be ease of use through the user's front-end tool (a client program that allows a user access to a database), but this, along with optimal performance, cannot be achieved if the user's needs are not taken into consideration. Some user-related research and design considerations in any business database include the following: What data should be stored in the database? How will the user access the database? What privileges does the user require? How should the data be grouped in the database? What data is the most commonly accessed? How is all data related in the database? What measures should be taken to ensure accurate......

Words: 1393 - Pages: 6

Premium Essay

Database Concept

...plans it well. The implementation should to be put in the right place. System implementation efforts offer extraordinary challenges to information technology professionals and the organizations impacted by the implementations. A successful implementation can reap vast rewards in organizational strengths and efficiencies. A failure can drain an organization of people, funds and vitality. Therefore, many people have been affected for reasons of success and failure experienced with the implementation. based on this case study rapid-implementation period of nine months to be implemented when the implementation of this system can be carried out as planned. The step of planning was: - 1. Interaction of technology and organization - a broad concept that laid the foundation for many other factors to consider. 2. User involvement and participation - is influenced by several variables that need to be carefully balanced to ensure a successful engagement. 3. Resistance - can work for or against the project depends on how it is managed. 4. Commitment - an important factor in the success but, as it involves various powers including the human soul (behaviour), it is a challenge to achieve and maintain. 5. Planning - more that can be controlled by project managers from other success factors and involves a lot of critical components. 6. Risk - inherent in each project, but can be expected and achieved success....

Words: 809 - Pages: 4

Free Essay

Database Concepts

...Huffman Trucking needs a better way to track the maintenance on their fleet of tractors, trailer and the roll-on/roll-offs. The fleet has to undergo periodic maintenance. Plan Putting the equipment's maintenance history, the parts used and vendor information into one database will save Huffman Trucking time and money. The database can include parts inventory information, parts catalogue information, the vendors used and their associated information, and parts purchasing history. The database will include all the maintenance history on each piece of equipment, such as the maintenance of the equipment itself, tire maintenance, the type of maintenance and the maintenance work orders. Conclusion Building a database saves money on maintenance by reducing redundant information and improving record keeping. Both the service and accounting departments will be able to utilize this database to keep track of parts purchases and costs. Having all the information in one central database would allow the diverse facilities to use the database. This type of centralization would bring more accuracy in Huffman Trucking's record keeping and would save money, time and manpower. Huffman Trucking Fleet Maintenance Database Solution Introduction Huffman Trucking is a privately held national transportation company with just under 1,400 employees and facilities across the United States. Huffman Trucking has benefited from a relationship with US Government that started in the late......

Words: 1795 - Pages: 8

Free Essay

Database Concepts

...1. What are the advantages of a declarative language as opposed to a procedural language? ANSWER: The advantage of declarative programming languages is mainly two-fold. The programs are concise; this makes it easy even for non-programmers to obtain solutions. In the SQL example above, an analyst or business support person can get the desired information. Similarly, laypersons can write acceptable web pages with simple HTML and CSS commands. The second advantage of the declarative programming model is that repetitive imperative code that indicates how to solve things is provided in the computer system behind the scenes. Such code can be made highly efficient and can incorporate the best ideas from computing. It can take advantage of parallelism 2. What advantages might a procedural language have over a declarative language? ANSWER: Procedural programming is used for developing simple applications. The languages that use the procedural programming methodology include Pascal and C languages. Some of the benefits of the procedural programming methodology are: (1) Easy to read program code. (2) Easy maintainable program code as various procedures can be debugged in isolation. (3) Code is more flexible as you can change a specific procedure that gets implemented across the program. 3. Why do you think cross joins are allowed as a legitimate join? What uses can you see for joins? ANSWER: I think that a cross-join would be optimized in the client library, so that......

Words: 317 - Pages: 2

Free Essay

Database Concepts

...Exploring the Latest ANSI and ISO Standard ANSI (American National Standards Institute) was founded in 1918, it is a voluntary organization composed of over 1,300 members (including all the large computer companies) that creates standards for the computer industry. For example, ANSI C is a version of the C language that has been approved by the ANSI committee. To a large degree, all ANSI C compilers, regardless of which company produces them, should behave similarly. In addition to programming languages, ANSI sets standards for a wide range of technical areas, from electrical specifications to communications protocols. The ISO was founded in 1946 and is currently headquartered in Geneva, Switzerland. Its mission at its inception was to create international standards regarding the threads of screws used for manufacturing world-wide. As needs for other standards arose, the ISO (then called the International Standards Organization, hence, ISO) stepped in to handle the task, and their influence crept into all areas of manufacturing and services. The primary focus for the ISO hasn't really been in the electrical and electronics area. Many of the standards set up in those areas were created by an older standards-setting organization called the International Electrotechnical Commission, or IEC, also based in Geneva. However, the ISO has responded to the needs of computing standards by forming a joint committee with the IEC dealing with information technology. The ISO has......

Words: 340 - Pages: 2

Premium Essay

Database Concepts Unit 1

...1. A recent trend for major commercial database developers is to offer free “Express” versions of their databases. Microsoft has SQL Express, Oracle has Oracle Express, and DB2 has DB2 Express. Go to the company websites, and look up these Express editions. What features does each one have? What limits do they have? How do they compare to each other? The features are: SQL Server Express supports most of the features and functionality of SQL Server. The following table lists some of the major features and components that are supported. Stored Procedures SQL Server Configuration Manager Views Replication (as a subscriber only) Triggers Advanced Query Optimizer Cursors SMO/RMO sqlcmd and osql utilities Integration with Visual Studio 2005 Snapshot Isolation Levels Service Broker (as a client only)¹ Native XML support, including XQuery and XML Schemas SQL CLR Transact-SQL language support Multiple Active Result Sets (MARS) Dedicated Administrator Connection² Import/Export Wizard The limits are: The following table lists the additional SQL Server database features that are not supported in this version of SQL Server Express. It also lists database features from previous versions of SQL Server that are not supported. SQL Server features not supported in SQL Server Express SQL Server features from previous versions not supported in SQL Server Express Database mirroring SQL Mail Online restore Fail-over clustering Database snapshot Distributed partitioned......

Words: 376 - Pages: 2

Free Essay

Database Concepts Research Assignment

...name can be uniquely determined from their SSN. However, the reverse statement (name -> SSN) is not true because more than one employee can have the same name but different SSNs.” Transitive dependency occurs when there is an indirect relationship that causes a functional dependency. While looking this up on the internet, it is hard to find a good example but in time I did. The example comes from http://databases.about.com/od/specificproducts/g/transitive-dependency.htm and from the website the example is and I quote “”A -> C” is a transitive dependency when it is true only because both “A -> B” and “B -> C” are true.” Demoralization is a strategy that database managers use to increase performance in their database. This is used to reduce certain types of problems that might come along with database queries that combine data from different tables into a single table....

Words: 267 - Pages: 2

Premium Essay

Pt2520 Database Concepts

...List the major topics for this database. The major topics of the database are: Lease Form (tracks leases of one apartment complex); Rent Payment Form (tracks rent payment of one apartment complex); Maintenance Request Form (tracks requests for maintenance and apartment manager’s resolution); Sample Quarterly Report (shows revenues and expenses of a particular building, address). STATEMENT OF WORK Project Name: Wild Wood Apartments June 21, 2014 • History: The Wild Wood Apartments are made up of 20 different complexes in Washington, Oregon, California and Idaho with each complex containing from 10 to 60 separate apartments. Leases are from 6 months to a year and the company’s practice is to hire one of the tenants to run the complex, collecting rent, conducting repairs, etc. The company requires a quarterly report to track the lease occupancy, rent payment, maintenance, and revenue and expenses; all of which is done in paper form. The forms are considered time consuming by the property managers, and the corporate office has concerns over their accuracy. A centralized database is being considered to simplify and better manage this data. • Scope: The contractor will include hardware, website, software and data storage support for the headquarters and all property offices that belong to Wild Wood Apartments. The main storage for the data will be offsite and the contractor is responsible for maintaining it. • Constraints: The contractor and the headquarters office of Wild...

Words: 706 - Pages: 3