Preview

Bis245 Ilab

Satisfactory Essays
Open Document
Open Document
2683 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Bis245 Ilab
A. Lab # : BSBA BIS245A-1 B. Lab 1 of 7 : Introduction to MS Visio and MS Access C. Lab Overview--Scenario/Summary TCOs: 1. Given a business situation in which managers require information from a database, determine, analyze and classify that information so that reports can be designed to meet the requirements. 2. Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool. Scenario: You have been asked to create two conceptual database models using MS Visio Database Model Diagram Template. The purpose of this lab is to have you gain familiarity with the various modeling tools needed to create a conceptual model (entity relationship diagram) of a database. You will create two conceptual models. You will then open an existing Access database to explore database objects and to experiment with simple data manipulation using filters and sorts and to begin elementary work with relationships. Upon completing this lab, you will be able to 1. relying on detailed instructions, create a simple conceptual model for a two-table database using MS Visio; 2. use experience gained in creating the first model to construct a similar conceptual model without the instructions; and 3. download an existing Microsoft Access database file. Open the database; find and identify different database objects in this database.

Page 1 of 31

D. Deliverables Section Part B Step 4 Part C Step 6 E. Lab Steps Preparation 1. Get the Database from Doc Sharing: a. Download Lab1_Nwind.accdb file from your course Doc Sharing panel (Labs view), and Save the file to your local drive b. Download Lab1C_Questions.docx from your course Doc Sharing panel, and Save the file to your local drive. 2. Using Citrix for MS Visio and/or MS Access a. If you are using the Citrix remote lab, follow the login instructions located in the iLab tab in Course Home. b. You will have to upload the Lab1_Nwind.accdb file to your
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Good Essays

    NT2670 Lab1 2
    • 1472 Words
    • 7 Pages

    NT2670 Lab1 2

    Each lab in this manual requires that you answer questions, save images of your screen, or perform other activities that you document in a worksheet named for the lab, such as lab1_2_worksheet. Your instructor will provide you with the worksheet files that you must complete for each lab. As you perform the exercises in each lab, open the appropriate worksheet file using WordPad, fill in the required information, and save the file to your…

    • 1472 Words
    • 7 Pages
    Good Essays
    Read More
  • Good Essays

    CMGT 400 Week 1 DQs
    • 676 Words
    • 3 Pages

    CMGT 400 Week 1 DQs

    The project for CIS336 is designed to touch all aspects of the fundamental concepts of database design and logical data modeling covered during the class. The project is team centered and each team will be responsible for designing, developing, and demonstrating the functionality of a database created based on a defined set of business specifications. At the end of the session, each project team will submit the database designed by the team and demonstrate the database's ability to deliver the required information as outlined in the project specifications. All aspects of the project will be ...…

    • 676 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Service Request Dba/380 Huffman Trucking
    • 553 Words
    • 3 Pages

    Service Request Dba/380 Huffman Trucking

    The Entity Relationship Diagram, also known as (ERD) demonstrates the relationship between data in the new database. ERD shows the logical path that the data follows. The data model gives one understanding and the visual representation to observe the different phases of the database and determine the path the information is pulled or stored from. Learning Team D demonstrate linking the different tables in the Fleet Truck Maintenance database. The creation of the logical path predicts the flow of the data entered and the tables relationship to other tables in the database.…

    • 553 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Ilab Instructions
    • 2258 Words
    • 10 Pages

    Ilab Instructions

    Download the Lab1_Nwind.accdb file from your course “DocSharing” panel (Labs view) and save the file to your local drive.…

    • 2258 Words
    • 10 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    DBM 380 Week 1 Individual Database Design Paper
    • 352 Words
    • 2 Pages

    DBM 380 Week 1 Individual Database Design Paper

    • Define relational database architecture. Consider Microsoft® Access*', Microsoft SQL Server®', Oracle®, IBM DB2®, and so on.…

    • 352 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    BU224 unit 1
    • 893 Words
    • 4 Pages

    BU224 unit 1

    3. Insert your answers below, or in the appropriate space provided for in the question. Your answers should follow the APA format with citations to your sources and, at the bottom of your last page, a list of references. Your answers should also be in Standard English with correct spelling, punctuation, grammar, and style (double spaced, in Times New Roman, 12-point, black font). Respond to questions in a thorough manner, providing specific examples of concepts, topics, definitions, and other elements asked for in the questions.…

    • 893 Words
    • 4 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Huffman Trucking Database Tables
    • 515 Words
    • 3 Pages

    Huffman Trucking Database Tables

    As part of this proposal, the below charts will diagram the database. It is to be used as a reference to the purposed database. Tables have been diagramed along with the proper schema, data types, and primary/secondary keys.…

    • 515 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    BIS 220
    • 808 Words
    • 4 Pages

    BIS 220

    With the advancements in technology we all are introduced to new or improved forms. There are times when advancing and learning of new technologies is a wonderful thing as long as one can also retain new information along with previously learned knowledge. In last week’s teachings we have learned new functions and capabilities as well as had a refresher course on the Microsoft PowerPoint program. Along with this informative we have also learned of the importance of the system development life cycle (SDLC) in regards to the planning, organizing, and implementing of information systems to include the project management of IT acquisitions, hardware and software selections.…

    • 808 Words
    • 4 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    Assignment1
    • 354 Words
    • 5 Pages

    Assignment1

    What problem would you encounter if you tried to create a listing by last name?…

    • 354 Words
    • 5 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Ist 7060 Project Scope And Communication Research Paper
    • 550 Words
    • 3 Pages

    Ist 7060 Project Scope And Communication Research Paper

    4. Technical requirements: - Latest SQL server i.e., SQL server 2014 sp1 (basic SQL commands), the latest version of Microsoft Visio 2013, Microsoft excel 2013 and Oracle Database 10g were the technical requirements of this…

    • 550 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Better Essays

    Huffman Fleet Truck Maintenance Database Specifications
    • 1925 Words
    • 8 Pages

    Huffman Fleet Truck Maintenance Database Specifications

    Our product is the creation of entity - relationship diagrams. The preliminary expectation is to have 11 to 12 tables and at least 6 queries available to create the necessary reports. Tables will be compiled using the existing reports from all…

    • 1925 Words
    • 8 Pages
    Better Essays
    Read More
  • Satisfactory Essays

    Efficiency and Collaboration Proposal
    • 400 Words
    • 2 Pages

    Efficiency and Collaboration Proposal

    Possessing the right collaborative tools when conducting business is essential; we have been using Microsoft Excel at Party Plates for quite some time now. In the search for a database that will be more compatible to hold and organize the data of the company, the capabilities of Microsoft Access will be what we are looking for. We want to highlight some keys elements that would help us in making that for the future of our business.…

    • 400 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Data Modeling Tools
    • 498 Words
    • 2 Pages

    Data Modeling Tools

    Visio 2003 provides specific solutions for Database diagrams that support the IDEF1X modeling technique, relational notations, object-relationship models, entity-level and schema-level diagrams, and product data models using EXPRESS-G notation. Diagrams can be created by dragging shapes to a drawing page or by reverse engineering an existing database structure from a variety of compatible databases, including Microsoft SQL Server™, Microsoft Access, Oracle, and IBM's DB2.…

    • 498 Words
    • 2 Pages
    Good Essays
    Read More
  • Good Essays

    Data Analysis and Data Modeling in Visio
    • 1049 Words
    • 5 Pages

    Data Analysis and Data Modeling in Visio

    This section will explain how to use Microsoft Visio to create conceptual Entity-Relationship data models. Microsoft Visio has built-in database tools for creating logical data models (those that apply the relational database theory to your entity-relationship diagrams), and not very good at conceptual modeling. As a result, using the MS Visio database tools to create the conceptual model diagrams can sometimes feel like trying to jam a round peg into a square hole.…

    • 1049 Words
    • 5 Pages
    Good Essays
    Read More
  • Good Essays

    Sql Server
    • 973 Words
    • 4 Pages

    Sql Server

    The purpose of this paper is to provide a comprehensive review of the SQL Server 2005 Express Edition for Beginners tutorial. The SQL Server 2005 Express database tutorial helps users understand what a database is, it explains how to create tables within a database and how users can covert flat databases into relational databases. This tutorial was basically designed to give users the basic knowledge of creating data bases. Databases are nothing more than a collection of files that work together to store data in a structured way. Some databases are made up simple files and others may require that severs manages connections to files within in a database to authenticate users that’s accessing those files. One of the main focuses of databases is how well organizations manage their database and maintains the accuracy of their data. Companies may want to use databases instead of text files because they provides them with more efficient data integrity, they can store more data, they can retrieve data in multiple ways, databases also provides organizations with the ability to protect their data from unauthorized users and protects their data from being corrupt. Relational Database Management Systems makes managing data for companies easier and it takes care of the difficult tasks associate with integrating data into their applications. Relational databases are the most common type of databases that are used today. The eliminate data redundancy which could cause companies to enter inaccurate data into their databases. Before relational databases were created data was managed by mainframe computers and the storage capacity was limited and very expensive to maintain. Relational databases reduces the amount of space on reel-to-real tapes that each database record required and they also reduced the cost of storing data and provided data integrity. Data integrity refers to the accuracy of the data that organizations are storing. With relational databases…

    • 973 Words
    • 4 Pages
    Good Essays
    Read More

Related Topics