Our Services

Get 15% Discount on your First Order

I want u to complete this assignment asap. Purpose: Build a new database with two database tables. 1. Create a new database entitled CompanyX2. Create the

March 25, 2024

I want u to complete this assignment asap.

Purpose: Build a new database with two database tables.

1. Create a new database entitled CompanyX2. Create the following database tables:

Employee- Name, Age, Address, ID,StartDate, EndDate, Phone Number, Department ID

Department-Name, Building Number, Department ID, SquareFeet, Active Status, BudgetAmount

• Set the primary key.• Be sure to set the data types accordingly.• Keep in mind that data should be stored in the optimal form for searching data.• Use camel case notation when naming the fields.• Use the caption field property for the employee table so the names in datasheet view are more user friendly.• Limit the employee’s name fields to 50 characters each.• Create a lookup datatype for the department name. Populate the lookup with four fictitious names of your choice for the user to pick from.• Join the tables. Enforce Referential Integrity.3. Define the following terms/acronyms:

a. Primary Key

b. Foreign Key

c. RDBMS

d. Referential Integrity

e. DBMS

f. Table

g. Record

h. Field

i. Relationship

j. Input mask

Upload your database to NEXUS.

4. Add additional table(s) to the JSP Recruiter’s database to accommodate recruiter dependents. It can be downloaded off the Access section of Nexus.

It is determined for benefit purposes that we must track each Recruiters family member(s). We should store the person’s name, address, and age.

Each recruiter can have many different dependents. A dependent could have many recruiters associated with them to account for things like marriages/family relations. Implement this in your database.

Keep in mind the relationship type.Set the primary keys as required.Add foreign key.Build all relationships in the relationship window.

Create one input mask for medical number. Assume the medical number is in this format: 12345, 65665.

Set the field length property for the length of address. Use your judgment as to the proper length. Be sure to set data types accordingly.

Implement a method in the database to make it possible to determine if the relationship between the Dependent and the Recruiter is current/in good standing.

hint- It is done in the new table you should have created.

5. Build a form best suited for each of your tables.

6. Find and save the following via query:a) Find all the Clients who owe more than 10k and are from City Berridge.b) Find Recruiters without clients.c) Count the number of Clients.d) Total the amount paid for all Clients.

Information Systems

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Continue collecting data for your community assessment. This week focus on data related to the 3 dimensions of a community (status, structure, and

Continue collecting data for your community assessment. This week focus on data related to the 3 dimensions of a community (status, structure, and process). List at least 3 sources you referenced for data collection. Community is Swansea, SC in Lexington County

Your discussion posting should include the following:1) Should answer the chosen question from the listing below (2 marks)2) Should tie in materials from

Your discussion posting should include the following:1) Should answer the chosen question from the listing below (2 marks)2) Should tie in materials from the assigned readings for that topic (2 marks)3) A reference list in APA format listing all references used in your response (1 mark) Unit 5: Food Safety

Case Briefing Legal issueWhat is being appealed? What is the legal issue?HoldingWhat is the decision of the appellate court? Did they reverse the

Case Briefing Legal issue What is being appealed? What is the legal issue? Holding What is the decision of the appellate court? Did they reverse the lower court decision or affirm it? Reasoning What is the reasoning behind the holding of the majority opinion? Are there any dissents? Concurring opinions?

Compose a ‘discussion’ in short essay form on insights garnered through a Jewish midrashic interpretation of the book of Numbers. (1 to 1.5 pages) How is

Compose a ‘discussion’ in short essay form on insights garnered through a Jewish midrashic interpretation of the book of Numbers. (1 to 1.5 pages) How is the book of Numbers a story about the themes of journey, freedom, responsibility, and the ‘in-betweens’ of life? Offer your impressions on such

Submit a 1,000-1,300-word policy change proposal on the country of Tanzania ‘s that formulates and proposes policy changes to reduce racial and ethnic

Submit a 1,000-1,300-word policy change proposal on the country of Tanzania ‘s that formulates and proposes policy changes to reduce racial and ethnic disparities. Include title and reference pages APA.

Please answer the following questions based off the Michael Morton videoINSTRUCTIONS Please answer the following questions based on the

Please answer the following questions based off the Michael Morton video INSTRUCTIONS Please answer the following questions based on the presentation: 1. Based on the information presented in the video, do you think Ken Anderson acted unethically in the Michael Morton case? Why or why not? Also, please research online and find out what

Select one text from the selection below for Essay#1: Article:”China Helped Raise My American Kids, and They Turned Out Fine” by Heather Kaye published in

Select one text from the selection below for Essay#1: Article:”China Helped Raise My American Kids, and They Turned Out Fine” by Heather Kaye published in New York Times. Video: “How AI is generating a revolution in entertainment” published in Youtube by The Economist Podcast: “Beyoncé, Björk and Donald Trump: What makes divas tick ”

Description Deliverable Length: 3-5 pages Write a brief summary of an intelligence and information-sharing strategy, either by a specific agency or in

Description Deliverable Length: 3-5 pages Write a brief summary of an intelligence and information-sharing strategy, either by a specific agency or in general as it applies to intelligence and information sharing. The summary will identify the following: The strategy The agency behind the strategy The primary goals, objectives, and policies within the strategy

To measure the financial performance of any company, it is important to analyze its four key financial statements: balance sheets, income statements, cash

To measure the financial performance of any company, it is important to analyze its four key financial statements: balance sheets, income statements, cash flow statements, and shareholders’ equity statements. In this assignment, you will: Visually present the balance sheet to depict what each company owns and what it owes over

Select one of the topics below:Autonomic computing Grid computing Nanotechnology N-tier client/server architectures On-demand computing Service-oriented

Select one of the topics below: Autonomic computing Grid computing Nanotechnology N-tier client/server architectures On-demand computing Service-oriented architecture (SOA) Storage area networks (SANs) Virtualization Write a research paper on the real-world application of the chosen technology. Your paper should include the type of organization(s) that benefits most from this technology.

Identify a famous set of siblings (e.g., Ann Lander and Dear Abbey, the Kardashian/Jenner siblings, Venus and Serena Williams, Michael Jackson and Janet

Identify a famous set of siblings (e.g., Ann Lander and Dear Abbey, the Kardashian/Jenner siblings, Venus and Serena Williams, Michael Jackson and Janet Jackson, JFK and Robert Kennedy, Ben and Casey Affleck) and explore how their birth positions, gender, physical attributes, their family’s trauma, social class, race and ethnicity, and

What terms do we have to refer to women and men who have never been married? What connotations are attached to these terms and what does this suggest to

What terms do we have to refer to women and men who have never been married? What connotations are attached to these terms and what does this suggest to you about gender and power?

Do children need both a mother and a father figure for optimal socio-emotional development? Explain your answer. In considering your stance, how may it

Do children need both a mother and a father figure for optimal socio-emotional development? Explain your answer. In considering your stance, how may it harm children to be raised in two-parent families where the couple relationship is conflicted and strained?

Discussion 1 Review the video “The Fifth Discipline in Three Minutes” located in the topic Resources. Peter Senge, author of the book The Fifth

Discussion 1 Review the video “The Fifth Discipline in Three Minutes” located in the topic Resources. Peter Senge, author of the book The Fifth Discipline: The Art and Practice of the Learning Organization said, “When I look at effort to create change in big companies over the past ten years,

While each paper focuses on a specific part of your manuscript, all papers have supporting materials to help you craft your paper. Each paper includes

While each paper focuses on a specific part of your manuscript, all papers have supporting materials to help you craft your paper. Each paper includes paper instructions (which are long and detailed but worth reading!), a grading rubric, a checklist, and two example papers from prior semesters. If you look

DISCUSSION MKT501 Module 3 Discussion: The Role of Marketing Public Relations (MPR) Discussion Post (Add to Company Website) Based on the resources

DISCUSSION MKT501 Module 3 Discussion: The Role of Marketing Public Relations (MPR) Discussion Post (Add to Company Website) Based on the resources provided or your research, use Marketing Public Relations (MPR) on the company website. Create a page that describes what your company offers the community (50-75 words of text

Explain how HRD methods can be used to help manage a culturally diverse workforce. For example, how will you overcome language and discrimination issues

Explain how HRD methods can be used to help manage a culturally diverse workforce. For example, how will you overcome language and discrimination issues that will ultimately lead to a climate in which all employees can thrive within the organization and contribute to its success? Develop a Training and Organizational