Program to build a database concerning employee information

Assignment Help Database Management System
Reference no: EM13166261

Company XYZ needs a program to build a database concerning employee information. The program should do the following:
Ask the employee for their name and number of dependents claimed for tax purposes.
Display a message to verify the number of tax deductions. (this will be one more than the number of dependents entered.)
Let employees select whether they want personal health insurance or family health insurance.
Display a message to verify the selection and tell each employee the cost of the selection.
Let employees select whether they want to deduct union dues from their paycheck.
Display a message to verify the selection and tell each employee the cost of the selection.
Show the OOD solution of this problem.
Step 1 Identify all nouns
Step 2 Identify class(es)
Step 3 Identify data members for each of the classes
Step 4 Identify operations for each of the objects (classes) 

Reference no: EM13166261

Questions Cloud

Write an arm assembly function that takes an array : Write an ARM assembly function that takes an array of integers and insures that all entries are positive. Remember the initial integer in the array is at index zero.
You are given for input the student name : Draw a flowchart to illustrate the following problem. You are given for input the student name, number of credits, and cost per credit. You need to output the student name, number of credits and total tuition.
What mass of o2 does the tank contain : Consider a steel tank whose volume is 65.0 L and which contains O2 gas at a pressure of 18100 kPa at 22°C. What mass of O2 does the tank contain?
Calculate the number of moles of o2 required to react : Calculate the number of moles of O2 required to react with phosphorus to produce 5.50 g of P4O6. (Molecular mass P4O6 = 219.9 g/mol.)
Program to build a database concerning employee information : Company XYZ needs a program to build a database concerning employee information.
Identify the components of the solid : The acid solution gives no precipitate when treated with 0.1 M AgNO3. Identify the components of the solid. EXPLAIN.
A class is derived from another one : In C++, when a class is derived from another one, you can specify the inheritance relationship as public, private or even protected. What are the main differences a between these types of inheritance in C++? How does a public inheritance differ from ..
Create listener objects for each jcombobox : Create listener objects for each JComboBox that set the background color of the panel when the user selects an integer. Use the current values supplied by the JComboBox objects to determine the background color.
State what is the equation for the equation cell reaction : Which electrode gains mass and which loses mass as the cell reaction proceeds? What is the equation for the equation for the overall cell reaction?

Reviews

Write a Review

Database Management System Questions & Answers

  Create an er diagram using the set of requirements

Create an ER diagram using the set of requirements provided for Oxford City Council's bicycle sharing scheme and identify the minimal set of functional dependencies and all candidate keys for the relation R

  Draw inheritance hierarchy to represent shoe object

Draw an inheritance hierarchy to represent a shoe object. The base class should have derived classes of Dress Shoes, Tennis Shoes and Boots.

  Illustrate concurrency control method by two phase locking

For each table argue whether or not interference with another transaction is possible. Illustrate concurrency control method using two phase locking.

  Explaining weak relationship and weak entity

What is meant by a weak relationship? Provide an example. What is meant by weak entity? What do you understand by relationship degree?

  Choose a data storage problem of storing data in database

You should choose a data storage problem of your interest and identify the different pieces of data that should be stored in database.

  Create data warehouse for electronics store chain

Create a data warehouse for electronics store chain. Chain has 20 stores in 5 cities. Each store has different sections comprising computers, DVDs, TVs, audio, home appliances etc.

  Create a table for patients with information

Create a table (by your own imagination) which comprises the least 25 patients with next information (columns): Calculate average of Value1 for each Gender.

  Write methods for outlier detection

Exceptions in credit card transactions can aid us fraudulent use of credit card. Suggest two methods for outlier detection.

  Various kinds of keys to form or define relationships

Relational database is based on fact that data in one table can be tied, or related to data in another table. To do this, database utilizes various types of keys to form or define these relationships.

  Draw an entity relationship diagram for the system

Draw an Entity Relationship diagram for the system and Identify the table design for the database displaying all the fields/attributes. Ensure that all tables are in 3NF. You also need to identify the primary keys and foreign keys, where applicable..

  Description of the relationship represented by scatterplot

Produce a scatterplot of Rent vs. Size (square meters of the apartment) for the rental data in rent.

  Write table in dbdl notation after applying methodology

Proceed with all steps in information-level design to add this user view to existing cumulative design. Is this table in1st NF?___No____ . If Yes skip. If not, write Table in DBDL notation after applying the methodology we use for converting into 1NF..

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