Preview

microsoft access

Satisfactory Essays
Open Document
Open Document
470 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
microsoft access
1a). Using the five tables below, create tables and link them through relationships. The tables should contain primary and foreign keys (where needed). (5 points)

Tables: City, Staff, Room, Hotel, and Guest.

1b). Using the five tables below, create tables and link them through relationships. The tables should contain primary and foreign keys (where needed). (5 points)

Tables: Book, University, Publisher, Library, and Author.

Section 2

2). Use the following information to create tables and link them through relationships. There are two pairs of relationships in this question. One of them is Department-Employee which has the relationship of one-to-many. The tables should contain primary and foreign keys (where needed). Do not create your own fields. Use the fields given to determine primary and foreign keys. Create three tables in Microsoft Access and input the data using forms (3 forms). Create a Form/Subform for the Department/Employee table and create a lookup column for BonusWitholdRate field in the Subsidiary table and Gender field in the Employee Table. Save the database as Subsidiary.

SubCode
SubName
BonusPayment
WithHoldRate
Revenue
Expense
S001
Lotus
875,000
.20
8,000,000
4,000,000
S002
Tulip
745,000
.18
6,000,000
2,000,000
S003
Daisy
925,000
.25
9,000,000
6,000,000
S004
Jasmine
765,000
.12
7,000,000
2,500,000
S005
Lavender
645,000
.10
7,000,000
3,500,000

DepartmentCode
Depart.Name
EmpNo
EmpName
EmpGender
D001
Finance
E001
Harry
Male
D002
HR
E002
Chris
Undefined
D003
Marketing
E003
George
Undefined
D004
Production
E004
Molly
Female
D005
R&D
E005
Angelina
Female

Create the following queries
1). Annual bonus after withhold which is more than $65,000
2). Annual net profit for each subsidiary.

Create a report based on the results of each query. Your first report should

You May Also Find These Documents Helpful

  • Satisfactory Essays

    3. (2 pts) Draw the ERD for the following scenario. Include all the attributes. Note that one of your tables will have a composite identifier.…

    • 298 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    Normalization of the database: This is a critical step for making the database. Normalization will help create table structures as well…

    • 3100 Words
    • 13 Pages
    Better Essays
  • Good Essays

    It2640 Week 5 Appendix B

    • 632 Words
    • 3 Pages

    Prior to designing my database, I will have a clear understanding of the data. This will allow me to determine the purpose of the database. Once all information is gathered, I will divide this information into tables. Information will be properly placed into columns and I will set a primary key. Upon completion of table design, I will set the relationships between tables. I will refine my design and apply normalization rules to my design.…

    • 632 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    b) You are to clearly mark Primary and Foreign Keys as shown in the sample below:…

    • 1494 Words
    • 19 Pages
    Powerful Essays
  • Satisfactory Essays

    3. Consider a table of data about employees. Which of the following fields are keys? Which one would you choose as the primary key? Employee ID Why? Because it is a unique number assigned to each employee.…

    • 421 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    b) 10 Convert the one table in the previous question to a relational database design. Fill each table in your…

    • 1445 Words
    • 6 Pages
    Powerful Essays
  • Satisfactory Essays

    • Define relational database architecture. Consider Microsoft® Access*', Microsoft SQL Server®', Oracle®, IBM DB2®, and so on.…

    • 352 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    This memo is to inform you that your service request SR-ta-001 has reached my desk and currently is in the process of being completed. The purpose of this memo is to report the progress on the service requests. Currently I am in the stage of normalizing the database to the third normal form. By normalizing the database to the third level of normalization I will ensure that the data is efficiently organized within the database by removing duplicate and redundant data from the database relations. Normalizing the data to the normal third will help free up space and make it easier for the users to retrieve the data by elimination of the same data stored in more than one relation. In addition, normalizing to this level will also ensure data integrity, scalability, and storage efficiency. I have made sure that that there are no repeating columns or rows within the same tables and each column has only one value and one data type therefore the level of 1 normalization has been completed. I then continued to normalize the database to the second level of normalization by ensuring that each nonkey attribute is fully dependent on the key columns of the table. Once level one and two normal form had been completed I continued by establishing primary and foreign keys along with relationships. I will keep in contact with you as the project nears completion.…

    • 329 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Doctor

    • 2483 Words
    • 9 Pages

    Identify the different types of entities, attributes, keys and relationships you will want to consider when designing the database.…

    • 2483 Words
    • 9 Pages
    Satisfactory Essays
  • Satisfactory Essays

    In this lab, you will prepare a Data Dictionary based on the list of elements. Also, your task will be determined the tables, their relationships, primary and foreign keys. Based on this analysis, you will create Database Schema, relational tables, Entity –Relational Diagram (ERD), establish connection to your local MySQL Server, create physical database and insert data to the tables.…

    • 1137 Words
    • 6 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Bis245 Ilab

    • 2683 Words
    • 11 Pages

    A. Lab # : BSBA BIS245A-1 B. Lab 1 of 7 : Introduction to MS Visio and MS Access C. Lab Overview--Scenario/Summary TCOs: 1. Given a business situation in which managers require information from a database, determine, analyze and classify that information so that reports can be designed to meet the requirements. 2. Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool. Scenario: You have been asked to create two conceptual database models using MS Visio Database Model Diagram Template. The purpose of this lab is to have you gain familiarity with the various modeling tools needed to create a conceptual model (entity relationship diagram) of a database. You will create two conceptual models. You will then open an existing Access database to explore database objects and to experiment with simple data manipulation using filters and sorts and to begin elementary work with relationships. Upon completing this lab, you will be able to 1. relying on detailed instructions, create a simple conceptual model for a two-table database using MS Visio; 2. use experience gained in creating the first model to construct a similar conceptual model without the instructions; and 3. download an existing Microsoft Access database file. Open the database; find and identify different database objects in this database.…

    • 2683 Words
    • 11 Pages
    Satisfactory Essays
  • Powerful Essays

    IST223-GHW7FS13

    • 2215 Words
    • 9 Pages

    Do parts A through M as given below. Those that involve SQL should be written…

    • 2215 Words
    • 9 Pages
    Powerful Essays
  • Powerful Essays

    In this document there will be an illustration of how to make tables and connecting them with the relationship in a diagram. This information will be worked in MySQL and below will have screenshots to help understand the process. Also throughout this document that will be data types listed some of these are Bit, Int, VarChar, Decimal, and Date (Kinter, 2012).…

    • 2177 Words
    • 9 Pages
    Powerful Essays
  • Powerful Essays

    This exercise will introduce you to the basic building blocks of any database – fields, records, and files (also called tables). Although you will create a database with a single table containing a small amount of data about computer vendors, the more applicable use of databases involves the creation of many tables linked together with a common field or “key.” Regardless of the size of the database, the data is stored in the same way – in fields which are combined to create a record. And those records are stored in a file or table. The data is entered into the field via a data entry form, and the information is extracted (to answer a particular question or need) via reports and/or queries.…

    • 1190 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    Discussion Board

    • 460 Words
    • 2 Pages

    I need to complete this assignment but I am having a hard time understanding it. Can someone give me some pointers on what to write on the DB? I just need a guide to start off with.…

    • 460 Words
    • 2 Pages
    Satisfactory Essays