Relational Model and Date / Time Short Date Essay

Submitted By stephenwinn1
Words: 1142
Pages: 5
Open Document
Planning a Working Relational Database
A: Purpose and Audience for the Database

Purpose of the data base:

Chester-le-Street Motors is a business which buys and sells cars. They have a large amount of customers, so a wide range of information is used. With CLS Motors selling and buying cars, it means that data input can become quite difficult and unorganised. The main purpose of creating the database is to organise data about the cars and the customers in such a way that it allows the information to be easily accessible and organised. Whilst also have the option to be updated and edited.

The main objectives are:

• Have an easy to use management information system.

• Have the ability to store information about the customers and the car.

• Be able to enter data easily and quickly.

• Have an option where you can find out certain information about a car or customer. For example: be able to search for Citroens under £3000, or females who are 21 or under.

• Improve organisation by having data available for the use of the CLS Motors staff.

• Reduce the amount of paper documents; this is because the majority of information will be stored within the database. It will include different lists, such as the car type, engine size, colour, model etc...

• All user interfaces will be customised with user-friendly menus.

• The main menu should be displayed automatically when the data base is opened and loaded.

• Increase organisation of the system for all of the CLS Motors staff.

• The database should be menu-driven.

Audience of the database

The user of the database will be the administrative staff and normal staff

The audience of the database will be the staff of Chester-le-street Motors. Information can be requested from other individuals but only the CLS motor staff will have access.

B: Table Structure

Table 1: Customer Table

|Primary Key |Field Name |Field Types |Field Lengths |Validation Methods |Input Masks |Combo Boxes |
|Primary Key |Customer ID |Text |7 |Required Field | | |
| |First Name |Text |25 | | | |
| |Surname |Text |25 | | | |
| |House Number |Number |Long Integer | | | |
| |Street |Text |50 | | | |
| |Town/City |Text |20 | | |Value List: |
| | | | | | |Chester-le-street; |
| | | | | | |South Pelaw; |
| | | | | | |Waldridge; Newcastle; |
| | | | | | |Sunderland |
| |County |Text |20 | | |Value List: Tyne, |
| | | | | | |Wear, Durham |
| |Post Code |Text |7 | |Input Mask: | |
| | | | |
Show More

Related Documents: Relational Model and Date / Time Short Date Essay

Essay on Syllabus: Sql and Utd

Dallas Course Info | Tech Requirements | Access & Navigation | Communications | Resources Assessments | Academic Calendar | Academic Integrity | Course Evaluation | UTD Policies Course Information Course Course Number Section Course Title Term and Dates MIS 6326.0W1 Data Management Spring 2015, January 12, 2015 – May 11, 2015 Professor Contact Information Professor Office Phone Email Address Office Location Online Office Hours Young U. Ryu 972-883-4065 ryoung@utdallas.edu SOM 3.426 by appointment…

Words 2211 - Pages 9

Normalization Of Database Tables

Chapter 5 Normalization of Database Tables Discussion Focus Why are some table structures considered to be bad and others good and how do you recognize the difference between good and bad structures? From an information management point of view, possibly the most vexing and destructive problems are created through uncontrolled data redundancies. Such redundancies produce update and delete anomalies that create data integrity problems. The loss of data integrity can destroy the usefulness…

Words 10105 - Pages 41

Essay about 500 Days

concepts are interpersonal attraction, stages of relational development, strategies for ending relationships, etc. From the very start of the movie we can see the different stages of relational development thanks to the way the movie was made, where you can see that in day 100 everything is happiness, and on day 300 things are starting to come apart. The “coming together” is when Tom meets Summer for the first time at their office, we clearly see that “short-term attraction” is well played on this scene…

Words 1433 - Pages 6

Mr_Ranjito Essay

transaction processing: batch processing and real-time processing. provide users with information about an organisation. These provide information about the performance of the organisation to the managers. This involves the production of reports on sales, inventory, payroll, orders and payroll. This is used to make decisions and motivate employees help decision-making. Decision support systems (DSSs) assist people to make decisions by providing information, models and analysis tools. A DSS can be used on…

Words 5484 - Pages 22

DELIA Design Document Essay

Version History |REVISION CHART | |Version |Author(s) |Description of Version |Date Completed | |1.1 |Hamed Rehman |First Design Document |Feb-2008 | | | |…

Words 6907 - Pages 28

Essay on Outputs of the Order Process

makes sure that the customer fills out all required fields. This will prevent the system from rejecting orders down the line due to incomplete information. The firm should avoid giving the customers the option of shipping in less than the standard time; unless in extreme cases. This will lead to less partiality and more fair treatment of customers. The order process also benefits from this because there is no strain on the system resulting from orders with rush deliveries. In order to better satisfy…

Words 2318 - Pages 10

Sarah E Essay

Ecological Engineering 37 (2011) 1709–1717 Contents lists available at ScienceDirect Ecological Engineering journal homepage: www.elsevier.com/locate/ecoleng Heavy metals in leachate from simulated green roof systems Sarah E. Alsup a,1 , Stephen D. Ebbs a,∗ , Loretta L. Battaglia a , William A. Retzlaff b a b Department of Plant Biology, Southern Illinois University Carbondale, 420 Life Science II, 1125 Lincoln Drive, Carbondale, IL 62901-6509, United States Department of Biological Sciences…

Words 9583 - Pages 39

Essay on turning points in online relationships

online dating reduced uncertainty regarding self-reported important topics. The results of this study found that there were a wide variety of self-reported turning points and important topics to discuss with a potential partner as well as a general time frame for both partners to agree to a physical meeting, overall honesty in self-representation and ways to reduce uncertainty. The most common turning points described by interviewees were: first contact, first contact outside of the dating site, first…

Words 7619 - Pages 31

Essay on Short Term Pastoral Counseling Final

Solution-Based, Short-Term Pastoral Counsleing Final Project By Mike Garner Presented to Dr. Robyn Simmons In partial fulfillment of the requirements of Introduction to Pastoral Counseling PACO 500 Liberty Baptist Theological Seminary Lynchburg, VA March 3, 2013 Abstract My future ministry will be as Co-Pastor of a medium sized Community Church in Lewisville, Texas. Each Sunday the church will have approximately 240 in attendance of Sunday morning worship service. My overarching…

Words 15205 - Pages 61

Design and Implementation of an E-Commerce Website Essay

THE DESIGN AND IMPLEMENTATION OF AN E-COMMERCE SITE FOR ONLINE BOOK SALES By tefera awetahegn Project Report Submitted to the faculty of the University Graduate School in partial fulfillment of the requirements for the degree Master of Science in the Department of Computer and Information Sciences mekelle university May 2007 Committee Members: Abstract The business-to-consumer aspect of electronic commerce (e-commerce) is the most visible business use of the World Wide Web. The…

Words 12168 - Pages 49