Wally Los Gatos and his partner Henry Chordate have formed a new limited partnership, Fin and Finicky Security Consultants. Fin and Finicky consults with corporations to determine their security needs. You have been hired by Wally and Henry to design a database management system to help them manage their business. Due to a recent increase in business, Fin and Finicky has decided to automate their client tracking system. You and your team have done a preliminary analysis and come up with the following set of entities, attributes, and business rules:
Consultant
There are two types of consultants: business consult-ants and technical consultants. Business consultants are contacted by a business in order to first determine security needs and provide an estimate for the actual services to be performed. Technical consultants per-form services according to the specifications developed by the business consultants.
Database Analysis Attributes of business consultant are the following: Employee ID (identifier), Name, Address (which is com-posed of Street, City, State, and Zip Code), Telephone, Date Of Birth, Age, Business Experience (which is com-posed of Number of Years, Type of Business [or busy-nesses], and Degrees Received).Attributes of technical consultant are the following: Employee ID (identifier), Name, Address (which is com-posed of Street, City, State, and Zip Code), Telephone, Date Of Birth, Age, Technical Skills, and Degrees Received.
Customer
Customers are businesses that have asked for consulting services. Attributes of customer are Customer ID (identifier), Company Name, Address (which is composed of Street, City, State, and Zip Code), Contact Name, Contact Title, Contact Telephone, Business Type, and Number of Employees.
Location
Customers can have multiple locations. Attributes of location are Customer ID (identifier), Location ID (which is unique only for each Customer ID), Address (which is composed of Street, City, State, and Zip Code), Telephone, and Building Size.
Service
Security service is performed for a customer at one or more locations. Before services are performed, an estimate is prepared. Attributes of service are Service ID(identifier), Description, Cost, Coverage, and Clearance Required.
Additional Business Rules
In addition to the entities outlined previously, the following information will need to be stored to tables and should be shown in the model. These may be entities, but they also reflect a relationship between more than one entity: Estimates, which have characteristics of Date, Amount, Business Consultant, Services, and Customer Services Performed, which have characteristics of Date, Amount, Technical Consultant, Services, and Customer in order to construct the EER diagram, you may assume the following: customer can have many consultants providing many services. You wish to track both actual serv-ices performed as well as services offered. Therefore, there should be two relationships between customer, service, and consultant, one to show services performed and one to show services offered as part of the estimate
just answer question below.
3) Create the SQL script that will generate atleast 4 tables in the data model that you have created
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
Wally Los Gatos and his partner Henry Chordate have formed a new limited partnership, Fin and...
1) Create Conceptual Schema Diagram 2) Create a fully attributed Loagical Data Model Diagram 3) Create the SQL script that will generate the data model Develop an EER model for the following situation using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor: Wally Los Gatos and his partner Henry Chordate have formed a new limited partnership, Fin and Finicky Security Consultants. Fin and Finicky consults with corporations to determine their...
Develop an EER (ER) model for the following situation using traditional EER notation. You have been hired by a new start-up company, IT Consulting – a company that consults with corporations to determine their security needs. You came up with the following set of entities, attributes and business rules: CONSULTANT 2 types of consultants – business consultants and technical consultants. Business consultants first work with a company for security needs, technical consultants perform services according to specs developed by business consultants. Attributes...
Q1.a) Based on the business rules, you are expected to construct an Entity-Relationship (ER) diagram. The ER diagram should include entities, attributes (if there are less than three specified in the business statements, please add some extra attributes), identifiers and corresponding data types, the relationships among entities with cardinality and associative entities. .b) Extend Q1.a) to apply generalization/specialization technique to construct an Enhanced-ER (EER) diagram. The EER diagram should specify the complete (total) and disjoint (mutuallyexclusive) constraints on the generalization/specialization....
You are a database consultant with Ace Software, Inc., and have been assigned to develop a database for the Mom and Pop Johnson video store in town. Mom and Pop have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database. You sit down with Mom and Pop to discuss their...
John and Jane Doe are married retired taxpayers who care for their three-year-old grandson. The following information was provided to you as documentation necessary to prepare their 2017 tax return. You will gather the appropriate information and complete the forms provided in Blackboard (1040, Schedule A, Schedule B and Schedule D) in preparation of their tax file. Please note that the forms provided may not match the tax year of the course, as IRS forms are not available until just...
Beverly and Ken Hair have been married for 3 years. Beverly works as an accountant at Cypress Corporation. Ken is a full-time student at Southwest Missouri State University (SMSU) and also works part-time during the summer at Cypress Corp. Ken's birthdate is January 12, 1993 and Beverly's birthdate is November 4, 1995. Beverly and Ken each received a W-2 form from Cypress Corporation (see separate tab). The Hairs have interest income of $1,000 on City of St. Louis bonds. Beverly...
Super stuck on a couple of questions on this scenario. Advanced Scenario 7: Mark and Barbara Matthews Directions Using the tax software, complete the tax retum, including Form 1040 and all appropri- ate forms, schedules, or worksheets. Answer the questions following the scenario. Note: When entering Social Security numbers (SSNS) or Employer identification Numbers (EINS), replace the Xs as directed, or with any four digits of your choice. Interview Notes • Mark and Barbara are married and want to file...
23. What is the total net amount of capital gain reported on Form 1040? OA. $308 OB. $2,411 C. $2,719 OD. $2,900 Advanced Scenario 7: Mark and Barbara Matthews Directions Using the tax software, complete the tax return, including Form 1040 and all appropri- ate forms, schedules, or worksheets. Answer the questions following the scenario. Note: When entering Social Security numbers (SSNs) or Employer Identification Numbers (EINS), replace the Xs as directed, or with any four digits of your choice....
using the information fill out the 1040 tax form 1:9-72 George Large (SSN 000-11-1111) and his wife Marge Large (SSN 000-22-2222) live at 2000 Lakeview Drive, Cleveland, OH 49001 and want you to prepare their 2017 income tax return based on the information below: George Large worked as a salesman for Toyboat, Inc. He received a salary of $80,000 ($8,500 of federal income taxes withheld and $1,800 of state income taxes withheld) plus an expense reimbursement from Toyboat of $5,000...
AO OUR CITY Department of the Treasury Service OMB Number Form 13614-C 2010 Intake/Interview & Quality Review Sheet You will need . Please complete pages 14 of this form, - Tax Information such as Forms W-2 100 100 1095 - You are responsible for the information on your return. Please provide - Social security cards or ITIN letters for persons on your tax retum complete and accurate information Picture D uchas valid driver's license for you and your spouse. ....