Preview

Working with Database Design

Powerful Essays
Open Document
Open Document
2266 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Working with Database Design
Phase Three Discussion Board Three

Working with Existing Data Management Systems

COPYWRITE (2013) BY Robert Ortega

MIS405 – 1302A -01: Database Design

Instructor: Anita Arceneaux, PhD

Wednesday, May 8, 2013; Sunday May 12, 2013

Colorado Technical University

Virtual Campus

Three other Requirements for Database Various other aspects and needed requirements are to be introduced and implemented into Jim and Tim’s new ACCESS™2010® Relational Database Management Systems from concepts, theories, analysis, import/export, referential integrity, primary/foreign/ non keys, data-modeling, and normalization. Needs to assure value, structure, relationship, and integrity are implemented in the relational database management systems (RDBMS) for the explicit users ability to flawless query information/data which allows by logical authentication to request, add, modify, and view correct, understandable intellectual organizational RDBS while using the export and import functions of ACCESS™2010®, EXCEL 2010, and MS SQL SERVER. One issue with almost all software (any type) is because humans write the code for software and on the other hand other humans reverse engineer written software finding weakness, and design script or bot code, which will become a threat agent in a form of a Trojan-horse, viruses, Dos, DDoS, and other forms of illegal hacking to steal intellectual data. A suggestion is using a specific tool called CAPTCHA “(Completely Automated Public Turing Test to tell Computers and Humans apart),” also known as “Gausebeck-Levchin Test.” This is to create anti-fraud detection, which prevents a script or a bot from being able to complete authentication. Although, this tool used in Pay-Pal transactions, its use for on-line of other types of internet web transactions to assure a live human interaction. This tool implementation into the accounting section between customers to RoboBoys and even between Jim, Tim, and vendors, which helps prevent the

You May Also Find These Documents Helpful

  • Powerful Essays

    Merged Logical design in 3NF format for the solution One. The merged logical design is also referred to as the Final Logical 3NF Design.…

    • 1494 Words
    • 19 Pages
    Powerful Essays
  • Satisfactory Essays

    • Define database architecture. For the database systems in your workplace, identify which architecture they fall under.…

    • 352 Words
    • 2 Pages
    Satisfactory Essays
  • Best Essays

    Even, A., & Shankaranarayanan, G. (2009). Quality in Customer Databases-Centered Review of Object Oriented Software Development Methodologies. ACM Computer Database, 15, 3,4,5. Retrieved September 12, 2013, from the ACM Computer database.…

    • 1383 Words
    • 5 Pages
    Best Essays
  • Good Essays

    Data integrity can be a major downfall when using information systems in the workplace as it relies on…

    • 512 Words
    • 3 Pages
    Good Essays
  • Best Essays

    Sidpers

    • 2831 Words
    • 12 Pages

    Afyouni, Hassan, Database Security and Auditing, Protecting Data Integrity and Accessibility, 2006 Thomson Course Technology…

    • 2831 Words
    • 12 Pages
    Best Essays
  • Satisfactory Essays

    For the larger scaled programs, the N Tier client/server architecture needs to be implemented. This client/server structure is able to increase to include a mid-level or business level tier, this structure has a server for…

    • 624 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Microsoft Access is a program specially designed to take in list data and turn it into tables and graphs that can assist the business operational process for organizations. Microsoft Access now uses browser-based database application that help run your business while keeping valuable information safe and secure in an SQL database-which is the most secure place to store information in the world! Access lets you build custom apps within their program that allows for you to create customized programs that are cloud based which are tailored for your specific business operational needs. Access also comes with an autocomplete function that remembers your repeat-information and fills in the data fields to save you time and valuable effort.…

    • 414 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    1. Let us design a database for an bank, including information about customers and their accounts. Information about a customer includes their name, address, phone, and Social Security number. Accounts have numbers, types(e.g., savings, checking) and balances. We also need to record the customer(s) who own an account. Draw the E/R diagram for this database. Be sure to include arrows where appropriate, to indicate the multiplicity of a relationship.…

    • 1441 Words
    • 6 Pages
    Good Essays
  • Satisfactory Essays

    Many legacy systems require normalization. Identify at least two factors that should be considered in order to produce an optimal normalized set of tables when performing normalization. Include in your discussion a detailed example on how each factor would eliminate data redundancy.…

    • 160 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    In this section I learned that SQL can input a lot of information into Access for you. I have taken some SQL courses before and still have not learned all of these commands. I can see why people take full degrees on just programming. Another thing I saw was SQL could do a lot of damage to Access. All you would have to do is write a script that could change a lot of information.…

    • 579 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Database Design Paper

    • 429 Words
    • 2 Pages

    A database system is a computer term for a structured set of data that can be saved, retrieved, added to or deleted from relatively easy. There are a variety of different databases and the type of database will determine how the data is arranged when it is stored and how that data will be located when it is called upon.…

    • 429 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Database Design

    • 418 Words
    • 2 Pages

    Before you use Microsoft Access to actually build the tables, forms, and other objects that will make up your database, it is important to take time to design your database. A good database design is the keystone to creating a database that foes what you want it to do effectively, accurately, and efficiently.…

    • 418 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Exploring Microsoft Access 2010 by Robert Grauer, Keith Mast, Mary Anne Poatsy Chapter 2 Relational Databases and Queries Copyright © 2013 Pearson Education,…

    • 1536 Words
    • 7 Pages
    Satisfactory Essays
  • Good Essays

    Database Organization

    • 691 Words
    • 3 Pages

    Here at the College of Veterinary Medicine, the databases that I have used are Microsoft SQLServer, Microsoft Access, and ProISAM. ProISAM is the type of database that Vetstar (our Hospital system) uses. It is the proprietary database for the PROIV programming environment that Vetstar is written in. The main problem with this database is that it is not ODBC compatible which just means that you cannot connect to it and query it directly with other programming languages such as Visual Basic. ODBC which stands for open database connectivity, is an industry standard for connecting to databases. We are planning to move the Vetstar database to a PostgreSQL database sometime in the next year. This will be ODBC compatible. Meanwhile we are now copying Vetstar tables to text and then loading them into a SQLServer database in order to be able to do the ad hoc queries that are needed. Other databases we maintain on SQLServer are the Personnel database which keeps track of employee information which, by the way, is the source for the college directory for CVM on our Web page and for the picture directory that is published each fall among other things; the Student Services databases which hold all of the information about our students ( personal, student schedules, grades, Web Admissions to the college); the Medical Records database which holds all of the abstract information for procedures and diagnosis pertaining to animal visits. We also have a SQLServer database which holds all of the archived data from VSI which is the hospital system we had before Vetstar.…

    • 691 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Essay Dbms

    • 548 Words
    • 3 Pages

    As our requirement for our DBMS subject, we interviewed Mr. Charleton Lopez, one of the database administrators hired by Accenture, last Saturday at SM Mall of Asia.…

    • 548 Words
    • 3 Pages
    Good Essays