COMR2002 : Business Information Systems : With the Current Growth in T
Developing the database will be provided during the week you are expected to implement a practical activity.
The following are the list of requirements:
- Create an E-R Diagrams using Diagram Editor
- Create database tables using LibreOffice Base
- Create queries and forms using LibreOffice Base and SQL
- Report on Impact using the technology
Answer:
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 |
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.
Buy COMR2002 : Business Information Systems : With the Current Growth in T Answers Online
Talk to our expert to get the help with COMR2002 : Business Information Systems : With the Current Growth in T Answers to complete your assessment on time and boost your grades now
The main aim/motive of the management 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 assignments. 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 urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.
