Build a workbook to an Excel user defined function and three unique Data Table examples. Construct and explain an example that answers a real-world problem using a one-way Data Table incorporating the new PVGOFA function as part of the model. The applied example should be unique and one of your choosing to include both a model and a Data Table. None of your three data table examples should involve a loan or model similar to one used in class. The values calculated in the body of the Table (the Table array functions) should cover a 10 by 3 array and reflect different parameter input values. The Table should be on the first sheet named One-Way and contain three output variables

Build a workbook to an Excel user defined function and three unique Data Table examples. Construct and explain an example that answers a real-world problem using a one-way Data Table incorporating the new PVGOFA function as part of the model. The applied example should be unique and one of your choosing to include both a model and a Data Table. None of your three data table examples should involve a loan or model similar to one used in class. The values calculated in the body of the Table (the Table array functions) should cover a 10 by 3 array and reflect different parameter input values. The Table should be on the first sheet named One-Way and contain three output variables

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 6HOA

See similar textbooks

Similar questions

Assume that you are a database specialist for Kulliyyah of Information and Communication Technology (KICT). You are required to create a conceptual data model for Abu Hurairah Club. The following are the data requirements gathered: The Abu Hurairah Club has a few animal shelters. Each shelter is identified by an identification number and has an address, a phone number, and a set of days on which it is open. A shelter is managed by one employee. An employee has an identification number, name, address, phone number, and a pay rate. A volunteer has an identification number, name, address, phone number, and a meal allowance. A person, who works at a shelter, is either an employee or a volunteer, but not both. A person may work at more than one shelter for some regular set of days each week. An animal is housed at one shelter. Each animal has an identification number that is unique to its shelter, a name, a birth date, and a species.
Create a data model to reflect the process of a consumer opening a checking account at a bank. The data model should be created using the data modeling utility in MySQLWorkbench. The model should contain at least five (5) entities. Each entity should have at least three (3) attributes.
Assume that you are a database specialist for Kulliyyah of Information and Communication Technology (KICT). You are required to create a conceptual data model for Abu Hurairah Club. The following are the data requirements gathered: The Abu Hurairah Club has a few animal shelters. Each shelter is identified by an identification number and has an address, a phone number, and a set of days on which it is open. A shelter is managed by one employee. An employee has an identification number, name, address, phone number, and a pay rate. A volunteer has an identification number, name, address, phone number, and a meal allowance. A person, who works at a shelter, is either an employee or a volunteer, but not both. A person may work at more than one shelter for some regular set of days each week. An animal is housed at one shelter. Each animal has an identification number that is unique to its shelter, a name, a birth date, and a species. Based on the requirements from a, b, c, d and e, draw…
Describe the general guidelines for structuring data-entry fields. Can you think of any instances when it would be appropriate toviolate these guidelines?
Create a logical data model documented with an ERD using the crow’s foot format. Be sure that each entity has the entity name at the top of the box, the primary key attribute or attributes in the middle of the box, and the non-key attributes in the bottom of the box. Lines should separate each part of the entity box. Follow these instructions about each ERD: ● The ERD must not have any many-to-many (m:n) relationships. ● All attributes must be placed within an entity. ● Each entity must have a primary key defined. A primary key can consist of one or more attributes. ● Each relationship must have a foreign key. Denote the foreign key(s) with the notation (FK) on the ERD. Remember that in a one-to-many relationship, the foreign key is placed in the entity that is on the many side of the relationship. ● Each relationship must include both a maximum and minimum cardinality for both sides of the relationship. ● Each relationship should have a verb or verb phrase to describe it. Question:…
The purpose of the assignment is to facilitate the learning of data modeling concepts through models developed by individuals. Things to be considered in the applications to be developed: Creating a model with at least 15 tables for vaccination tracking system. The characteristics and relationships of the tables are in the model. Step by step analysis of the normalization steps for a table with multiple relationships in the model. It will briefly be stated which entity-tables will be used for what purpose. Only special rules will be added in the relational data model that cannot be directly specified.
Create an airline database. Customers and their bookings must be kept in the database, as well as flights and their status, seat allocations on specific flights, and future flight schedules and routing. An E-R diagram, relational schemas, and a list of constraints, including primary-key and foreign-key constraints, should all be included in your design.
Which of the following is a key part of conceptual design in an entity relationship model? This model uses column names instead of attributes. In this model, the characteristics such as location, path, and format are described. This model converts entities into tables. In this model, no primary keys are specified in the entities.
What steps can you take to guarantee that your model has all of the data it needs to function properly?What are the benefits of using data modeling strategies for the formulation of issue statements?
Create an Entity-Relationship Model for the Queen Anne Curiosity Shop The first assignment for the class project is to create an entity-relationship model of the Queen Anne Curiosity Shop database. This assignment requires you to apply the knowledge gained from study of chapter 4 of the textbook. You will create the entity-relationship model using the ERDPlus database modeling tool. The Queen Anne Curiosity Shop database contains the following tables: CUSTOMER (CustomerID, LastName, FirstName, Address, City, State, ZIP, Phone, EmailAddress) EMPLOYEE (EmployeeID, LastName, FirstName, Phone, EmailAddress) VENDOR (VendorID, CompanyName, ContactLastName, ContactFirstName, Address, City, State, ZIP, Phone, Fax, EmailAddress) ITEM (ItemID, ItemDescription, PurchaseDate, ItemCost, ItemPrice, VendorID) SALE (SaleID, CustomerID, EmployeeID, SaleDate, SubTotal, Tax, Total) SALE_ITEM (SaleID, SaleItemID, ItemID, ItemPrice) Note that the above table descriptions follow the textbook convention:…
Develop a simple data model for a student database that includes student data, student contact data, student demographic data, student grades data, and student financial data. Determine the data attributes that should be present in each table, and identify the primary key for each table. Develop a complete entity relationship diagram that shows how these tables are related to one another.
Below is a sample of an assignment roster of employees working in a company. An assignment involves a specific job given to a specific employee, on a specific date and time, and in a specific section of a specific building. Very specific. You've identified the following entities: Assignment, Employee, Section, Building, Job. No others. Use the information below to infer which entities have relationships with each other, as well as the types of those relationships, and constraints if any. All that you should submit is a set of the relevant business rules. Once again, remember that entities don't necessarily directly connect, unless the information collected specifies that they are connected. In case you need extra info: ● Section is a kind of code given to a section in a specific building. Each section has a completely unique code (across all buildings) e.g. F3 only exists in building "Flora", not any other building. ● Section N is short for "section name"; it's the name of the section…