Create database tables using libreoffice base

Assignment Help Database Management System
Reference no: EM131606667

BUSINESS INFORMATION SYSTEMS DATABASE APPLICATION ASSIGNMENT

Learning Outcomes -

1. Apply practical skills in the major functions of spreadsheet and database tools.

2. Communicate with IT professionals, stakeholders and user groups of information systems.

Instructions:

Students are expected to develop a database for the case study provided. Students need to design and implement the database using LibreOffice Base.  Students will be having several database-related practical activities during the semester and each practical activity contributes to the completion of your assignment.  Additional information you need in 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.

Attachment:- Assignment Files.rar

Reference no: EM131606667

Questions Cloud

Changing foreign currency exchange rates : What financial impact can changing foreign currency exchange rates have on a multi-national company?
Discuss stress and time management : How do you think classical and operant conditioning and cognitive learning play a role in terms of your study habits, and stress and time management
What is her real income today in terms of constant : However, on average, goods today cost 8.1 times what they did in 1950. What is her real income today in terms of constant 1950 dollars?
Invested at a continuously compounded interest rate : How much will $100 grow to if invested at a continuously compounded interest rate of 8.25% for 7 years? What if it is invested for 8.25 years at 7%?
Create database tables using libreoffice base : COMR2002 BUSINESS INFORMATION SYSTEMS DATABASE APPLICATION ASSIGNMENT. Create database tables using LibreOffice Base
What is the diathesis stress model : What is the diathesis stress model. how can it be used to help us understand the manifestation of mental illness in different people
Create a schedule that shows the aftertaxcashout- flows : Create a schedule that shows the aftertaxcashout- flows. Create the schedule thatcombinesinterest expenses and depreciation expenses.
Discuss the symptoms of bipolar disorder : How are the symptoms of bipolar disorder similar to those of other disorders in children, a problem that might create confusion for diagnosing
Differentiate databases data warehouse and data mining : Select any mid to large company. Research the following about your company. Determine its mission, vision, and goals. Discuss its IT architecture.

Reviews

len1606667

8/21/2017 2:49:39 AM

Australian student, I need it to be done as soon as possible. It have only these three problems to solved and you have to follow the brief with the instructions please, It was u have to make 3 tables on excel. Total 3 word files need to be done, The pdf have some instructions for how they should be done. Its database assignment. An ER diagram and database works in libre office needed to be done. The aim of this assessment is to assess the student’s ability to solve business problems using database design tool and software. Weekly online practical work will help students to complete this assessment.

len1606667

8/21/2017 2:49:13 AM

Many companies depend on the accurate recording, updating and tracking of their data on a minute-to-minute basis. Employees access this data using databases. An understanding of this technology allows business professionals to be able to perform their work effectively. Students need to submit the following: First one A word document containing: Introduction - a summary of the case study, Database - explanation of the database development activities, E-R Diagrams created, Database tables created using LibreOffice Base, SQL queries and the reports generated by those queries and second one is LibreOffice Base files used in creating the tables, queries and forms.

len1606667

8/21/2017 2:49:06 AM

Document exceeds minimum standards and exhibit high quality presentation. Summary shows sophisticated understanding of the case study and database development activities. Document is presented and formatted excellently. E-R Diagram created was complete and correct. All entities, attributes and relationships were correctly identified. Database table is complete and correct. All entities are correctly and completely translated into tables. Attributes and types of attributes were correctly identified. All data in the table were entered. All table relationships were correct (primary and foreign keys and their relationships were all correctly identified). All SQL queries and reports generated were correct. All elements of the forms were correctly created, have been linked to the tables, and can correctly save data entered. Forms have very good design.

Write a Review

Database Management System Questions & Answers

  Excel for decision support modeling

Willy Wonka is considering starting a production line to produce fizzy lifting drinks. As Chief Oompa Loompa (COL) you have access to a wide variety of financial data to help you determine whether bringing the new production line on will be a sma..

  Draw a level one dfd for the handle advocacy process

Rockland county in Long Island has an active taxi workforce of over 1500 taxi drivers and a very active taxi union. Draw a LEVEL 1 DFD for the HANDLE ADVOCACY process.

  Create an access database table with the title providers

Create an Access Database table with the title: Providers. Create a second Access Database table with the title: Nurses.

  Write the 10 cardinalities for entity relationship diagram

Write the 10 cardinalities that are appropriate for the ERD (Entity Relationship Diagram)

  What is a relational database

What is a relational database-Write a 1500 word essay on the above question. Your response should include the evolution of 1st generation data models

  Jdbc enables applications to exchange data

JDBC enables ____ applications to exchange data with any database that uses SQL statements and is compliant with the

  Describe some typical pairs of entities

Describe some typical pairs of entities that you think might be common in business, and describe their relationships, whether many-to-many, one-to-many, many-to-one, or one-to-one. Explain why you think that a particular relationship applies to th..

  Investigate the role of corporate venturing

A corporate venture has the resources of a large organisation and the entrepreneurial Benefits of a small one

  Database design proposal product in the final phase of the

in the final phase of the database design proposal assignment you are required to design a working prototype of the

  Describe the logical database design

Report on Logical Database Design Good DBAs must be able to prepare a full design report. You should hand in the full, legible report (hopefully typeset).

  Write a select statement that joins the categories table

Write a SELECT statement that joins the Categories table to the Products table and returns these columns: CategoryName, ProductName, ListPrice.

  Create a flowchart and pseudocode using control breaks

The system should store the current inventory levels for different raw materials in a file.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd