Comr2002 : Business Information Systems Assessment Answer

Answer:

1.Database
 
1.1 Development activities

To develop the database and thorough review of the case study is done to come up with the relations and their attributes. After deriving the relations and their relationships from the case study normalization is done. Normalization involves three steps;

  • Normalization to 1NF- Normalization to 1NF involves taking the relations identified from the case study and then removing all repeating groups.
  • Normalization to 2NF- Normalization to 2NF involves taking the relations achieved by normalization to 1NF and then eliminating partial dependencies in the relations such that there is only one candidate key and no other combination of attributes can form a candidate key.
  • Normalization to 3NF. Normalization to 3NF involves taking the relations achieved in 2NF and eliminating the transitive dependencies to make sure that there is only one key attribute which determines all the other attributes.
  • After normalization to 3NF the relations can be implemented as tables in a database.

    1.2 Entity relationship diagram

    1.3 Relational schema

     

    Table

    Attribute

    Data Type

    Costraint

    Sales_rep

    Sales_rep_NO

    NUMBER

    Primary key

     


    Last_name

    VARCHAR(50)

     

     

    First_name

    VARCHAR(50)

     

     

    Contact_no

    VARCHAR(25)

     

     

    county

    VARCHAR(50)

     

     

    Total_commission

    DECIMAL

     

     

    Commission_rate

    DECIMAL

     

    Customer

    cusotmerNO

    Number

    Primary key

     

    Name

    VARCHAR(50)

     

     

    streetAddress

    VARCHAR(50)

     

     

    City

    VARCHAR(50)

     

     

    State

    VARCHAR(50)

     

     

    Zip

    VARCHAR(50)

     

     

    County

    VARCHAR(50)

     

     

    creditLimit

    DECIMAL

     

     

    creditCardNO

    VARCHAR(50)

     

     

    creditCardType

    VARCHAR(50)

     

     

    salesRepNO

    NUMBER

    Foreign key references sale_rep.sales_rep_no

    product

    productID

    NUMBER

    Primary key

     

    Name

    VARCHAR(50)

     

     

    Colour

    VARCHAR(50)

     

     

    Size

    VARCHAR(50)

     

     

    quantityAvailable

    NUMBER

     

     

    unitPrice

    DECIMAL

     

     

    manufacturerID

    NUMBER

     

    Order_line

    OrderNumber

    NUMBER

    Primary key

    Foreign key references order.orderNumber

     

    productID

    NUMBER

    Primary key

    Foreign key references product.productID

     

    QuotedPrice

    DECIMAL

     

     

    quantity

    NUMBER

     

    Order

    OrderNumber

    NUMBER

    Primary key

     

    customerNO

    NUMBER

    Foreign key references customer.customerNO

     

    orderDate

    Date

     
     
     
    1.4 Impact of using technology

    With the current growth in technology, organizations are finding it easy to run their business operations by incorporating technology in their business activities. Most organizations generate very large volumes of data from their business operations. The large volumes of data are generated as a result of normal day to day activities in the organization or its branches. Handling this data using manual methods like use of physical files to store the data leads to a lot of work for the employees thus makes it hard to operate the business efficiently. Retrieving data is a very hard task when there is large volumes of data stored on physical files. To deal with this problem, organizations are using information systems to improve the business process by simplifying the way data is recorded, stored and accessed. Continued use of information systems within an organization leads to a better organization as the activities that are carried out using the information systems are carried more easily and with more accountability.

    With the data collected using information systems, organizations are using the data to get business insights from the data by implementing data ware houses to perform business intelligence. The large volumes are not just archives of data but help improve the decision making process of organizations. For the Grand Prix project, the information system will help improve the business process. The business will be able to maintain data for all of its customers. This data will be very useful to the organization as it can help evaluate how the business is performing. The information system will also improve the process of making orders for customers. If the information system is implemented as a web application customers will be able to make orders from the application. The order will be processed and the inventory updated. All this data will be stored in a database thus the organization will have data for all the customers and orders made by customers as well as maintain the inventory. Evaluation of this data can help the organization perform simple business analysis like customer segmentation where by customers with the most orders are identified.

    However implementing the information system has an impact on the cultural issues as customers will change the way they make orders to something easy which can be done from a web application. The security of the data will be determined how the secure the information system will be developed. The development of the project should make sure the data is safe from malicious users. This will help protect the privacy of the users because if such information lands on malicious users the privacy of the customers can be violated if the data is distributed. Thus implementing information systems has many advantages for organizations but they should target to use the information system to improve the business but also make sure that the information system will not violate existing laws and regulations.

    Download Sample Now

    Earn back money you have spent on downloaded sample



    Upload Document Document Unser Evaluion Get Money Into Your Wallet



    Cite This work.

    To export a reference to this article please select a referencing stye below.

    Assignment Hippo (2022) . Retrive from https://assignmenthippo.com/sample-assignment/comr2002-business-information-systems-assessment-answer

    "." Assignment Hippo ,2022, https://assignmenthippo.com/sample-assignment/comr2002-business-information-systems-assessment-answer

    Assignment Hippo (2022) . Available from: https://assignmenthippo.com/sample-assignment/comr2002-business-information-systems-assessment-answer

    [Accessed 29/05/2022].

    Assignment Hippo . ''(Assignment Hippo,2022) https://assignmenthippo.com/sample-assignment/comr2002-business-information-systems-assessment-answer accessed 29/05/2022.



    Buy Comr2002 : Business Information Systems Assessment Answers Online

    Talk to our expert to get the help with Comr2002 : Business Information Systems Assessment Answers from Assignment Hippo Experts to complete your assessment on time and boost your grades now

    The main aim/motive of the finance assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignment help Australia. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at www.assignmenthippo.com are so much skilled, capable, talented, and experienced in their field and use our best and free Citation Generator and cite your writing assignments, so, for this, they can effectively write the best economics assignment help services.

    Get Online Support for Comr2002 : Business Information Systems Assessment Answer Assignment Help Online

    Want to order fresh copy of the Sample Comr2002 : Business Information Systems Assessment Answers? online or do you need the old solutions for Sample Comr2002 : Business Information Systems Assessment Answer, contact our customer support or talk to us to get the answers of it.

    Assignment Help Australia
    Want latest solution of this assignment

    Want to order fresh copy of the Comr2002 : Business Information Systems Assessment Answers? online or do you need the old solutions for Sample Comr2002 : Business Information Systems Assessment Answer, contact our customer support or talk to us to get the answers of it.


    Submit Your Assignment Here

    AssignmentHippo Features

    On Time Delivery

    Our motto is deliver assignment on Time. Our Expert writers deliver quality assignments to the students.

    Plagiarism Free Work

    Get reliable and unique assignments by using our 100% plagiarism-free.

    24 X 7 Live Help

    Get connected 24*7 with our Live Chat support executives to receive instant solutions for your assignment.

    Services For All Subjects

    Get Help with all the subjects like: Programming, Accounting, Finance, Engineering, Law and Marketing.

    Best Price Guarantee

    Get premium service at a pocket-friendly rate at AssignmentHippo

    FREE RESOURCES

    • Assignment Writing Guide
    • Essay Writing Guide
    • Dissertation Writing Guide
    • Research Paper Writing Guide

    FREE SAMPLE FILE

    • Accounts
    • Computer Science
    • Economics
    • Engineering

    Client Review

    I was struggling so hard to complete my marketing assignment on brand development when I decided to finally reach to the experts of this portal. They certainly deliver perfect consistency and the desired format. The content prepared by the experts of this platform was simply amazing. I definitely owe my grades to them.

    Tap to Chat
    Get instant assignment help