Premium Essay


In: Computers and Technology

Submitted By dogzen
Words 627
Pages 3
M8A1: Database Project Report
Jeff Sowell
Excelsior College
Professor Harold Lamson

This paper details the database project for this class. Including the steps taken to develop it, how it is being developed, queries and an E/R diagram of the model, each of which will be discussed in this paper.

Database Project Report
The term project is focused on building a database management system for the telematics company: Ozark Inc. which provides telematics software as a service. Ozark Inc. has run into challenges around maintaining and organizing its data since the company has been growing rapidly, and expanding its customer base. As a result, we will be building a database management system for Ozark Inc. which will help them create efficient business processes by identifying key pieces of information, which includes customer data and metadata, sales information, employee information and details regarding the products Ozark Inc. sells.
Database design is being driven by information provided by key stakeholders in the business, who have also provided details of current business workflow and process, sales policies, and specific constraints the business has around resources to allocate to the aforementioned. Company employees have documented, and shared what they believe is important and which should be addressed by a database system. The data model requires a relational database which will use multiple tables to store, and manage the data needed by the company. The software which will be utilized in the project is MS Access, because of its ease of use in manipulating data, and the relatively intuitive user interface it offers makes it an appropriate platform to develop the database system for Ozark Inc.

The database will contain the following tables: * Customer_Information, Customer_Sales_Detail, Employee_Info, Sales_Info, Product_Detail,...

Similar Documents

Premium Essay


...Expenditure Cycle Lecture Notes COSO Framework within the Expenditure Cycle Control Environment- the tone at the top of the organization. Without clear, demonstrated commitment of upper management and opinion leaders in the organization, internal control will not be taken seriously elsewhere in the hierarchy. Human resource policies – buying organization must conduct business with integrity Delegation of authority – assigns levels of purchasing allowed by job description Risk Assessment-using a taxonomy, business experience, research, and dialogue to identify the risks associated with operations. Expensive goods – risk of theft or other loss Violating FCPA Control Activities- the actual internal controls implemented on the basis of the risk assessment. See grid Information and Communication- • For an internal control system to function effectively, its purpose, methods, and results must be communicated throughout the organization. Employees at all levels should understand the risk exposures they face and the controls employed to mitigate those exposures. • Information must be accurate, valid, classified correctly, and in the proper accounting period. Monitoring- SOX mandates internal control monitoring and personal certification by the CEO and CFO of the organization. Companies’ objectives and business processes change over time, so the monitoring function in an important part of the maintaining good internal control. Waren......

Words: 300 - Pages: 2

Premium Essay

Cosc 1301 Final

...• Question 1 1 out of 1 points When a Web page author includes meta keywords, like sex, that have little to do with the information on the page, the author is engaging in ____. Answer Selected Answer: d. keyword stuffing Correct Answer: d. keyword stuffing • Question 2 1 out of 1 points ____ is the most frequently used HTTP method. Answer Selected Answer: b. GET Correct Answer: b. GET • Question 3 1 out of 1 points Researchers estimate that the most extensive search engines cover less than 20% of the Web. Answer Selected Answer: True Correct Answer: True • Question 4 1 out of 1 points The ____ wildcard character allows a search engine to find pages with any derivation of a basic word. Answer Selected Answer: c. * Correct Answer: c. * • Question 5 1 out of 1 points HTML ____ are typically used to collect shipping and payment information during checkout at an e-commerce Web site. Answer Selected Answer: d. forms Correct Answer: d. forms • Question 6 1 out of 1 points PayPal is a pioneering example of a(n) ____ payment system. Answer Selected Answer: c. P2P (person-to-person) Correct Answer: c. P2P (person-to-person) • Question 7 1 out of 1 points Which of the following Web-based applications is NOT sometimes characterized as Web 2.0? Answer Selected Answer: d. cloud computing Correct......

Words: 4931 - Pages: 20

Premium Essay

Se Habla Espanol

...Analyze combat and operational stress reactions (COSRs) Combat Stress Controlling combat stress is often the deciding factor between victory and defeat in all forms of human conflict. Stressors are a fact of combat, and you and your Soldiers will face them. Controlled combat stress can call forth stress reactions of loyalty, selflessness, and heroism. Conversely, uncontrolled combat stress causes erratic or harmful behavior that disrupts or interferes with the accomplishment of a unit’s mission. Any uncontrolled combat stress can impair mission performance and may bring disgrace, disaster, and defeat. The art of war aims to impose so much stress on enemy soldiers that they lose their will to fight. Both sides try to do this and at times accept severe stress themselves in order to inflict greater stress on the enemy. To win, you must control combat stress. The word “control” is better than the word “manage” to emphasize the active steps that leaders, supporting personnel, and individual Soldiers must take to keep stress within an acceptable range. This does not mean that control and management are mutually exclusive terms. Management is, by definition, the exercise of control. Within common usage, however, and especially within Army usage, management has the connotation of being a somewhat detached, number–driven, higher echelon process rather than a direct, inspirational, leadership process. Stress is the body’s and mind’s process for dealing with uncertain......

Words: 7902 - Pages: 32

Free Essay


...Forskellen på den længste fisk og den korteste fisk i juni og september: * Juni: 244 cm. - 140 cm. = 230 cm. * September: 268 cm. -228 cm. = 40 cm. Dvs. at junis fisks længde er mere bredte (altså der er større forskel på den længste end den korteste) end septembers. Septembers kvartilboks ligger over junis, dvs. at fiskene i september i gennemsnit var større end i juni. Dog kan vi se at junis er længere, hvilket betyder at junis fisks længde er mere spredt. Opgave 9: a) Vi kan ud fra tabellens data at: * a=0,592092 * b= 0,233769 b) Dvs. at der går ca. 74,5 min. da vandet løber over. Opgave 10: a) BC=a2=b2+c2-2bc*CosA↔ a2=142+72-2*14*7*cos37=88,46744003 88,46744003=9,405713159 b) CosC=a2+b2-c22*a*b CosC=9,42+142-722*9,4*14=235,36263,2 vinkel C=0,894224924 vinkel c ≈26,5 grader 180 grader-A-B=D 12A=18,5 grader C=26,5 grader D=135 grader c) dsinD=csinC=asinA 14sin135=142 2=1,41421 14*1,41421=19,7989=csin26,5 19,7989=c0,446197813 19,7989*0,4461978=8,83422562242=AD Opgave 11. a) Opgave 12. a) Arealet af M: b) Arealet af N: Opgave 13: a) For at finde overflade arealet af en kasse bruger man normalt følgende formel: A=2*længde*bredde+længde*højde+bredde*højde O er normalt lig...

Words: 394 - Pages: 2

Free Essay

Product Catalogue

...THE ASPRE Y WATCH CATALOGUE BRITISH LUXURY GOODS SINCE 1781 Asprey represents style, refinement and quality – British classicism expressed with a modern spirit. Founded in 1781, Asprey is still today the ultimate authentic British Luxury Lifestyle House. 2 Asprey is renowned for fine jewellery, watches and clocks, leather goods, silver, china, crystal, ready to wear, accessories and fragrance. THE ASPRE Y WATCH COLLECTIONS The Asprey watch collections, for men and for women, perfectly capture the Asprey spirit of craftsmanship married with design, of classic sensibilities expressed with a modern flair. Whether inspired by British instruments for travel and exploration or original designs from the Asprey archive, each Swiss watch is made with exquisitely produced movements and materials of the finest quality. The intrinsic elegance of the exclusive collections, from the No. 8 range to ladies jewelled watches, is complimented by superb functionality. Even in the simplest detail – the use of sapphire anti-reflective glass or luminova numerals – practicality and beauty are delicately balanced. This is the unmistakable Asprey signature.  THE N O . 8 WATCH COLLECTION The collection takes its name and inspiration from the historic Asprey 8 day travel clock, famous for its 8 day winding system and power reserve. Made with the finest Swiss technology, the No. 8 collection features watches from the 8 Day Limited Edition to the Chronograph. The Asprey heritage is......

Words: 4305 - Pages: 18

Premium Essay

Animal Therapy in the United States Military

...Animal Therapy in the United States Military Marti Powell University Composition and Communication II/COM156 November 25, 2013 Tamra Excell Thesis: The United States Military has different animal therapy programs designed to help Wounded Warriors and active deployed soldiers, and has been doing so since the year 1919. I. Animal-Assisted Therapy A. Definition 1. Differences 2. The Heart B. In the Beginning 1. Thru the years 2. Documentation II. Deployment A. War Zone 1. SFC Boe and Budge 2. Trauma and Reassignment B. Lessons 1. Policy 2. Health III. Walter Reed National Military Medical Center A. Programs 1. Dog Tags 2. Warrior Transition B. Nonprofit 1. Qualifications 2. Benefits Abstract Information for this research paper was obtained by reading articles written for the U.S. Army Medical Department Journal, April-June, 2012. These articles were written about the use of canines by the military for Animal-assisted Therapy in the military. All articles are......

Words: 2034 - Pages: 9

Free Essay

Mathe Formulae

...1 SOME IMPORTANT MATHEMATICAL FORMULAE Circle : Area = π r2; Circumference = 2 π r. Square : Area = x2 ; Perimeter = 4x. Rectangle: Area = xy ; Perimeter = 2(x+y). 1 Triangle : Area = (base)(height) ; Perimeter = a+b+c. 2 3 2 Area of equilateral triangle = a . 4 4 Sphere : Surface Area = 4 π r2 ; Volume = π r3. 3 2 3 Cube : Surface Area = 6a ; Volume = a . 1 Cone : Curved Surface Area = π rl ; Volume = π r2 h 3 π r l + π r2 Total surface area = . Cuboid : Total surface area = 2 (ab + bh + lh); Volume = lbh. Cylinder : Curved surface area = 2 π rh; Volume = π r2 h Total surface area (open) = 2 π rh; Total surface area (closed) = 2 π rh+2 π r2 . SOME BASIC ALGEBRAIC FORMULAE: 1.(a + b)2 = a2 + 2ab+ b2 . 2. (a - b)2 = a2 - 2ab+ b2 . 3.(a + b)3 = a3 + b3 + 3ab(a + b). 4. (a - b)3 = a3 - b3 - 3ab(a - b). 2 2 2 2 5.(a + b + c) = a + b + c +2ab+2bc +2ca. 6.(a + b + c)3 = a3 + b3 + c3+3a2b+3a2c + 3b2c +3b2a +3c2a +3c2a+6abc. 7.a2 - b2 = (a + b)(a – b ) . 8.a3 – b3 = (a – b) (a2 + ab + b2 ). 9.a3 + b3 = (a + b) (a2 - ab + b2 ). 10.(a + b)2 + (a - b)2 = 4ab. 11.(a + b)2 - (a - b)2 = 2(a2 + b2 ). 12.If a + b +c =0, then a3 + b3 + c3 = 3 abc . INDICES AND SURDS m n mn (ab)m = a m b m am 1. am an = am + n 2. = a m − n . 3. (a ) = a . 4. . an m am −m = 1 a 5.   = . 6. a 0 = 1, a ≠ 0 . 7. a . 8. a x = a y ⇒ x = y m am b b 9. a x = b x ⇒ a = b 10. a ± 2 b = x ± y , where x + y = a and xy = b. S B......

Words: 2819 - Pages: 12

Premium Essay

Case Study

...Jale Arnutlu COSC 3325 Infosys Technologies: The Implementatin Challenges of Knowledge Management Initiatives A central knowledge management (KM) group created a major initiative that they called knowledge currency unit (KCU). They considered that this system would help and start contributions to the Kshop. The system organized for Infosys employees, which has a power to control knowledge for provide corporation, to contribute to Kshop. Therefore, Kshop would be awarded KCUs and exchanged into monetary rewards or prizes. On the other hand, this system caused an information load and higher search costs for returnable knowledge so that it became successful and extreme growth. However, this system also caused degradation of the quality knowledge and also a heavy burden for the limited number of volunteers reviewers. Knowledge Management group implemented KCU a monetary reward in exchange for reviews in the Kshop. By this way, Kshop would increase employee visibility and also their standing. And this action improved employee performance. However, one of the biggest implementation was that the employees the lack of new system the knowledge. Knowledge management group decided to follow important steps, such as they shared valuable information with community to explain the perception of benefit Kshop. And also they also wanted to show tangible proofs to increase the high ratings of the reviewers. Thus, knowledge management group became successful its initiatives, and this......

Words: 403 - Pages: 2

Free Essay

Computer Science

...DATA MINING COSC 5371 ASSIGNMENT 1 DATE: 02/26/2016 NAME: AMAN REDDY GURRAM Student ID: 6001093799 A) Write scripts in R to display mean vectors, standard deviation, scatter diagrams, parallel coordinates signatures of each class for the following datasets. > data(iris) >#Finding Mean of each class > mean(iris$Sepal.Length) [1] 5.843333 > mean(iris$Sepal.Width) [1] 3.057333 > mean(iris$Petal.Length) [1] 3.758 > mean(iris$Petal.Width) [1] 1.199333 >#Finding Standard Deviation > sd(iris$Sepal.Length) [1] 0.8280661 > sd(iris$Sepal.Width) [1] 0.4358663 > sd(iris$Petal.Length) [1] 1.765298 > sd(iris$Petal.Width) [1] 0.7622377 >#SCATTER DIAGRAMS >with(iris, plot(Sepal.Length, Sepal.Width, col=Species, pch=as.numeric(Species))) OUTPUT: > pairs(iris) OUTPUT: >install.packages("scatterplot3d") >library(scatterplot3d) >scatterplot3d(iris$Petal.Width, iris$Sepal.Length, iris$Sepal.Width) OUTPUT: >#PARALLEL COORDINATES > library(MASS) > parcoord(iris[1:4],col=iris$Species) OUTPUT: > library(lattice) > parallelplot(~iris[1:4] | Species, data=iris) OUTPUT: B) Write a script to classify the datasets using any one classifier >#CLASSIFICATION USING C5.0 ALGORITHM >#command to install package C5.0 > install.packages("C50") > require(C50) >#Process to shuffle the rows of data set iris randomly > set.seed(9850) >......

Words: 340 - Pages: 2

Free Essay

Case Paper 2

...Singhquaverton Maden COSC 3325 4/5/13 Jie Arrendell Case 2: Raymond James Financial, BCD Travel, Houston Texans, and Others: Worrying about What Goes Out, Not What Comes In I think the reason why employees don't realize the dangers is because the events which are less sensitive to the management of the company's employees are not important in regulating confidentiality of data and information systems. As we can see from the case there are several examples of the proposed event where there's less rigorous regulation in the supervision of information systems within the company. Most of the issues described in the case are simple little issues such as emailing customer credit card numbers and such but I would have definitely have seen these issues but the lapse of these company have cost them security wise. The best way for organizations to strike the right balance between monitoring and invading their employees' privacy would be to evaluate each employees based on their activities. Have each employee make a report of their activities while the company is monitoring them as well the companies should put trust in their employees to report everything they're doing and when it is time to evaluate them cross compare what has been monitored and what the employees have reported. The consequence biased to one side would be if the company were to engage in just invading employee privacy there could be massive repercussions such as the company being sued etc...

Words: 343 - Pages: 2

Free Essay

Assignment Timeline

...ASSIGNMENT TIMELINE—COSC 2425   Dates | Text Chapters | Pages and sections covered | Assignments | Week 1June 6th – June 11th |  Chapter 1: Basic Concepts Chapter 2: x86 Processor Architecture | Page 1-28 Pages 29-57 | Read all material in the Getting Started Folder, read the syllabus (located on the Course Home tab), read the assignment timeline and grading sheet.Assignment 1: Introduce yourself to the class (Located in the Getting Started Folder) Quiz Chapter 1 Quiz Chapter 2 | Week 2June 12th –June 18th | Chapter 3: Assembly Language Fundamentals Chapter 4: Data Transfers, Addressing, and Arithmetic | Pages 58-93 Pages 94-131 | Quiz Chapter 3 Quiz Chapter 4 | Week 3June 19th –June 25th | Chapter 5: ProceduresChapter 6: Conditional Processing | Pages 132-179 Pages 180-228 | Quiz Chapter 5 Quiz Chapter 6 Programming Project 1 (Covers Chapters 1-6) | Week 4June 26th – July 2rd | Chapter 7: Integer Arithmetic Chapter 8: Advanced Procedures | Pages 229-269 Pages270-331 | Quiz Chapter 7 Quiz Chapter 8 | Week 5July 3rd – July 9th | Chapter 9: Strings and Arrays Chapter 10: Structures and Macros | Page 332-365 Pages 366-418 | Quiz Chapter 9 Quiz Chapter 10 Programming Project 2 (Covers Chapters 1-10 concentrating on the concepts learned in chapters 7-10) | July 4th Holiday | | | No Class | Week 6July 10th – July 12th | Comprehensive and covers all chapters (1-10) | | FINAL EXAM on Tuesday July 12th, 2011...

Words: 324 - Pages: 2

Premium Essay

Medical Coder

...Medical Coder Melanie Hadnot Professor:  Michelle Levack  HIT-120-62856 November 20,2015 Medical coding specialist play an important role in the healthcare field. Using alphanumeric diagnosis codes they communicate important information about medical conditions and treatment. Coders translate medical terms into a specific format, allowing information to be send accurately between the physician and the insurance carrier. Correct coding ensures that the patient's medical conditions are recorded properly, verification of the provider’s services and appropriate reimbursement by the payers for their services. Additionally, codes are used by public health agencies to track public health threats, provider performance and to identify potential areas of financial or medical fraud within the healthcare industry. When coding is done properly, patients, providers and payers all benefit. Medical coding specialists work in a variety of settings, both clinical and non-clinical. Clinical settings may include hospitals, surgical centers, physician offices, dental offices and home health agencies. Coders who work outside the clinical setting may work for insurance companies, independent billing and coding services and public organizations. Most Coding specialist work full time in a business office environment coding clinical data from patient charts. They use a variety of resources to code correctly for services, supplies and diagnosis, including ICD and CPT codebooks. Becoming a......

Words: 794 - Pages: 4

Free Essay

Ikea Case Study study); and analysis of secondary data including the CIA Factbook and the MarketLine Furniture Industry Report for the Czech Republic. ... The report concludes that the Czech Republic represents an appropriate target country for IKEA over the next decade and recommends further primary and desk research to establish the precise size and nature of the opportunity. The country chosen for this assignment is the Czech Republic which is characterised by being both a transition (CIA, 2014) and emerging (Bloomberg, 2013 country market. In the past decade it has witnessed an average increase in per capita income of 4% per annum (World Bank, 2014) and an improvement in standards of living, with an average disposable spend of €1,200 per annum (CoSc, 2013). Political...

Words: 840 - Pages: 4

Free Essay


...COSC 5313-01 Analysis of Algorithms Instructor: Jing Zhang Assignment #3 Due: 23:59:00, 04/06/2016 Name : sai kishen thentu LUID : L20398443 Date : 04/06/2016 1. Write pseudocode for RIGHT-ROTATE. Answer: RIGHT-ROTATE (T, x) Y = x.left x.left = y.right //set y // turn y’s right subtree into x’s left subtree if y.right != T.nil y.right.p = x y.p = x.p if x.p == T.nil T.root = y elseif x == x.p.right x.p.right = y else x.p.left = y y.right = x x.p = y // link x’s parent to y //put x on y’s right 2. Please show the red-black tree that results after TREE-INSERT is called on the tree shown below with: 1) Key 40. If the inserted node is colored red, is the resulting tree a red-black tree? What if it is colored black? (16 points) 2) Key 22. If the inserted node is colored red, is the resulting tree a red-black tree? What if it is colored black? (16 points) Answer: (1) If the node with key 40 is inserted and colored red, the red-black tree becomes: We can see that it violates following red-black tree property: A red node in the red-black tree cannot have a red node as its child. So the resulting tree is not a red-black tree. If the node with key 40 is inserted and colored black, the red-black tree becomes: We can see that it violates following red-black tree property: For each node, all paths from the node to descendent leaves contain the same number of black nodes (e.g. consider node with key 30). So the resulting tree is not a red-black tree either. (2) If......

Words: 836 - Pages: 4

Free Essay

Add Math Folio

...TABLE OF CONTENT TITLE | PAGE | TABLE OF CONTENT | 1 | APPRECIATION | 2 | OBJECTIVE | 3 | METHOD INVESTIGATION | 4 | PART I | 5-7 | PART II | 8-10 | PART III | 11-13 | PART IV | 14-16 | REFLECTION | 17-18 | CONCLUSION | 19 | APPRECIATION First of all, I would like to say thank you for giving me the power to complete this project work. Not forgotten my parents for providing me any material to complete this project and their support which are the most needed for this project. Internet, books, computer and the list goes on. They also supported me and encouraged me to complete this project so that I will not procrastinatein doing it. For their strong support, I would like to express my gratitude to my beloved parents. They also helped me to find the mark to complete this project. They have always been at my side and I hope that they will still be there in the future. Besides, I would like to thank my Additional Mathematics teacher, Pn. Phong Bee Bee as she had gave us some important guidance and commitment during this project work. She has been a very supportive figure throughout the project. Then I would also want to thank my teacher for guiding me and my friends throughout this project. We had faced some difficulties in doing this task, but she taught us patiently until we knew what to do. She had tried to teach us until we understand what we supposed to do with the project work. I also want to thank my friends for assisting me to......

Words: 3034 - Pages: 13