Create relationships between the tables

Assignment Help Database Management System
Reference no: EM131348545

Assignment - Database Management System (DBMS)

Applicable course objective:

  • demonstrate problem-solving skills by identifying and resolving issues relating to information systems and their components, and proficiently utilise different types of information systems software (especially gaining proficiency in utilising databases, spreadsheets, and presentation applications).
  • demonstrate written communication skills by understanding basic information communication and technology (ICT) terminology for effective communication and applying it within a business environment.

Applicable graduate qualities and skills gained from this assessment instrument:

  • Problem Solving (Skill U2)
  • Written & Oral Communication (Skill U4)

Preamble

Dr Rod N Berry retired in 2012 after a long career in Logistics Management.To keep busy and to fulfil a lifelong dream, Dr Berrystarted a Memorabilia mail order business, specialising in Star Trek Memorabilia related products called the "The Borg Collective" and began selling various types of imported Star Trek merchandise such as statues, replicas, giftware, clothing and other assorted Star Trek paraphernalia to customers via mail order around Australia. These types of Star Trek merchandise have become very popular, especially since J.J. Abrams' reimagining of the franchise with Star Trek (2009), Star Trek Into Darkness (2013), Star Trek Beyond (2016) and the new Television series called Stat Trek Discovery (2017) have brought the phenomenon back into the public's attention. Dr Berry has experienced a rapid growth in their mail orders. When Dr Berryretired, the business bought a personal computer to help manage the books and finances.

The Borg Collective is located at Shop 1, 701 Shatner Boulevard, Toowoomba (about 100 km west of Brisbane). Dr Berry can be contacted via phone on (07) 4637 4656; fax on (07) 4637 4205; or email on [email protected].

Dr Berry is extremely impressed with our computing firm "Klingon Systems" and the business has contracted our firm to assist them in setting up their information systems.

The first information system that Dr Berryis interested in is a Database Management System (DBMS) using Microsoft Access (any version from Access 2007 to current). The DBMS will be used to store all of the business's customer details, information about the stock items that the business sells, the suppliers that the business uses and all postal order transactions for the business. It will allow Dr Berryto run a number of queries on the data which the business has specified below and they wish to be able to print out an invoice for each customer at the end of every month.

All phases in this project must be developed with professionalism and user-friendliness in mind.

Dr Berry has provided us a partial list of the business's customers, stock items, and suppliers and a partial list of herpostal orders for the second quarter 2016(Apr - Jun) to use as test data in four tab delimited text files (*.txt) which can be found on your firm's Intranet (CIS1000 Study Desk).

Mr Sev N O'Nine, your manager, has set up the following tasks for you to complete for this phase of the project:

1. Create a Database and import the four (4) Text files into four (4) Tables.

2. Modify Table Design.

3. Set Primary Keys.

4. Create Relationships between the Tables.

5. Create Data and Update Queries.

6. Create Data Display Forms.

7. Create an Invoice Report.

8. Create an End of Project Presentation to the Client.

Attachment:- Assignment.rar

Reference no: EM131348545

Questions Cloud

Determine the thermal efficiency : The turbine inlet state was 200. psig and 400.°F, the generator produced 2.00 MW, and the plant had a heat rate of 35.0 × 103 Btu/(kW · h). Determine its thermal efficiency.
Describe the nature of educational dualism : Describe the nature of educational dualism in developing countries and its implications for the character of growth. Also, elaborate on how the LDC educational system actually contributes to the reproduction of social inequality across generation..
Number of firms selling homogenous : A large number of firms selling homogenous (identical) products serve an industry. Each of the firms has the following cost structure: + 10Q + Q2, so that +2Q. The firm-level cost structure holds regardless of how many firms enter the industry. De..
Determine the isentropic power output of the turbine : Determine the isentropic power output of the turbine.- The isentropic efficiency of the turbine-generator unit.- The isentropic Rankine cycle thermal efficiency of the power plant.
Create relationships between the tables : Mr Sev N O'Nine, your manager, has set up the following tasks for you to complete for this phase of the project: Create a Database and import the four (4) Text files into four (4) Tables. Modify Table Design. Create Relationships between the Tables
What is company operating cash flow : During 2014, Raines Umbrella Corp. had sales of $780,000. Cost of goods sold, administrative and selling expenses, and depreciation expenses were $610,000, $85,000, and $115,000, respectively. What is Raines’s net income for 2014? What is the company..
Contributor to sustained economic growth : It is sometimes said that declining fertility was a major contributor to sustained economic growth among the Asian tigers. Do you agree with this view? Use the microeconomic theory of fertility to argue that it was a rise in wages, spectacular g..
Large gas guzzling vehicles : A sudden and sharp increase in gas prices will have what impact on the market for the following (be sure to discuss both supply and demand):
Considering should have interest rate risk premium : Stu wants to earn a real return of 3.4 percent on any bond he acquires. The inflation rate is 2.8 percent. He has determined that a particular bond he is considering should have an interest rate risk premium of .27 percent, a liquidity premium of .08..

Reviews

len1348545

1/10/2017 4:07:57 AM

Please follow this guidelines in all assignments - most of the references in the paper should be academic journal and books and they should be published after 2010 (references before 2010 published year are not acceptable, second word count of the assignment means words excluding references and toc. The words for toc and references are not counted and third one if not mentioned in the assignment requirement, the organisation should be australian (organisations from other countries are not acceptable). This assignment must be all your own work. It is acceptable to discuss course content with others to improve your understanding and clarify requirements, but solutions to assignment questions must be done on your own.

Write a Review

 

Database Management System Questions & Answers

  Display structure of the i_model table

Display structure of the i_model table. Display all the information stored in the i_model table belonging to car group ‘A4'.

  Prepare a report related to business communications

Prepare a report - The report should be related to Business communications.

  Describe what the role of the database administrator is and

discuss what the role of the database administrator is and why it is such an important role in the company. do we

  What are the candidate keys of r

Compute the closure sets of R - find all non-trivial dependencies and what are the candidate keys of R?

  Write and execute sql definition commands

Write the SQL DDL to create the database that contains each of the relations shown in the above ERD and write and execute SQL definition commands

  Examine structures rather than describing them with text

The ____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text

  Implement the entity relationship model

Implement the entity relationship model provided in the sample solution of Assignment - Map the ERD into a set of relations in at least Third Normal Form (3NF). You must ensure that your relations meet 3NF. There is no need to show your working.

  Write down advantage in storing metadata in tables

What is meant by a Metadata? How does this term pertain to a database? Write down advantage is there in storing metadata in tables?

  Create a relational database using ms access

Create a relational database using MS Access

  Create new blank database in access and save using your name

Create the attributes (fields) for each table. Field names should be fully qualified (i.e. the table name should be included as part of the field name. Field names should not contain spaces (e.g. CustomerLastName)).

  What a query execution plan

What a query execution plan? Discuss the reasons for converting SQL queries into relational algebra queries before optimization is done

  Create three use case diagrams for the new billing

Using the Hillside School Case Study and your stage 1, 2, and 3 projects, develop a decision paper that serves as a system "sign-over" document for system deployment and transfer of responsibility for the newly designed and implemented system to t..

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