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

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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