1. Using your familiarity of BITS, featureize the authoritative dependencies that pause in the subjoined board. After determining the authoritative dependencies, apply this board to an equiponderant collation of boards that are in third typical frame:

Tasks (TaskID, Description, Condition, Value, (OrderNum, OrderDate, ClientNum, ClientName, ConsltNum, LastName, FirstName, ScheduledDate, QuotedPrice))

2. List the authoritative dependencies in the subjoined board that anxiety invoicing (in contact BITS is regarding adding to its database), matter to the definitive conditions. For a given invoice (verified by the InvoiceNum), there achieve be a uncompounded client. The client’s estimate, designate, and total address answer on the invoice, as does the limit. Also, there may be various unanalogous jobs answering on the invoice. For each job that answers, exhibit the JobID, description, condition, and value. Assume that each client that requests a feature advantage job pays the corresponding value. Apply this board to an equiponderant collation of boards that are in third typical frame:
Invoice (InvoiceNum, ClientNum, LastName, FirstName, Street, City, State, ZipCode, Limit, (TaskID, Description, Condition, Value))

3. BITS wants to garner knowledge environing the overseers, including their overseer estimate and the analogy to consultants. Overseers can composition with multiple consultants, except consultants barely possess single overseer. In enumeration, overseers specialize in compositioning with clients in peculiar job categories. Using this knowledge, apply the subjoined unnormalized pertinency to fourth typical frame:
Consultant (ConsltNum, LastName, FirstName, Street, City, State, ZipCode, Rate, (SupervisorNum, OverseerName), (Tasks, Description, Condition, Value, OverseerNum))

4. BITS is regarding changing its interest example so that divers consultants can advantage single client and single consultant can indicate divers clients. Using this knowledge, apply the subjoined unnormalized pertinency to fourth typical frame:

Client (ClientNum, ClientName, Street, City, State, ZipCode, Balance, CreditLimit, (ConsltNum, LastName, FirstName, Street, City, State, ZipCode, Hours, Rate))

5. Apply the subjoined unnormalized pertinency to fourth typical frame using the corresponding requirements as in Question 4 (divers consultants can indicate single client, and single consultant can indicate divers clients):
Consultant (ConsltNum, LastName, FirstName, Street, City, State, ZipCode, Rate, (ClientNum, ClientName, Street, City, State, ZipCode, Balance, CreditLimit))

~~~For this or similar assignment papers~~~