Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services.Figure 2-32 shows data that Garden Glory collects about properties and services.Suppose Garden Glory decides to add the following table:SERVICE-FEE (PropertyID, ServiceID, Description, Amount)Add this table to what you consider to be the best design in your answer to part B. Modify the tables from part B as necessary to minimize the amount of data duplication. Will this design work for the data in Figure 2-31? If not, modify the design so that this data will work. State the assumptions implied by this design. FIGURE 2-31Employee Salary64,000.0070,000.0070,000.0064,000.0064,000.0058,000.0070,000.0058,000.00ProjectID100-AEmployeeNameEric JonesDonna SmithDonna SmithEric JonesEric JonesEric ParksDonna SmithEric ParksSample Data forRegional Labs100-A100-B200-A200-B200-C200-C200-D

Answered: Image /qna-images/answer/bf50852c-74ff-4df1-b215-d9aec6fa78f4.jpg

Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services. Figure 2-32 shows data that Garden Glory collects about properties and services. Suppose Garden Glory decid

Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services. Figure 2-32 shows data that Garden Glory collects about properties and services. Suppose Garden Glory decid

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter4: Analyzing And Charting Financial Data

Section4.1: Chart Elements

Problem 6QC

See similar textbooks

Similar questions

Create and ERD based on the Crow's Foot Model, using the following requirements. Include Primary Keys, Foreign Keys, and Relationship types (weak/strong): 1. An INVOICE is written by a SALESREP. Each sales representative can write many invoices, but each invoice is written by a single sales representative. 2. The INVOICE is written for a single CUSTOMER. However, each customer can have many invoices. 3. An INVOICE can include many detail lines(INV_LINE), each of which describes one product bought by the customer. 4. The product information is stored in a PRODUCT entity. 5. The product's vendor information is found in a VENDOR entity.
Consider the File Structure for the XYZ Company Project Management data given below. Then, respond to each of the following questions related to the structure. ProjectCode ProjectManager MgrTelephone MgrLocation ProjBidPrice 31-205A Sami A. Allen 773-555-1216 2900 S. Federal St. Chicago, IL 60616 $46,000 37-403B Cecily D. Worth 773-555-1217 27 Beckley Rd. Battle Creek, MI 49015 $1,342,000 33-906T Daisy B. Burns 773-555-8821 2543 W. Foster Ave. Chicago, IL 60625 $847,320 29-107D Alice M. Zane 773-555-1219 7202 Harrison Ave. Rockford, IL 61112 $1,449,000 21-929A Dean P. Pence 773-555-2222 6302 N. Northwest Hwy. Chicago, IL 60631 $903,117 41-386C Cecily D. Worth 773-555-1217 27 Beckley Rd. Battle Creek, MI 49015 $1,805,000 26-903C Sami A. Allen 773-555-1216 123 Lane St. Chicago, IL 60616 $78,081 29-227A Cecily D. Worth 773-555-1217 27 Beckley Rd. Battle…
pls help me : Draw an ER diagram databse management for hospital according to the following requirements:Department - stores information about hospital departments, including department ID and department name. Staff - stores information about doctors and nurses, including staff ID, staff name, and department ID (foreign key referencing Department entity). Patient - stores information about patients, including patient ID, patient name, gender, date of birth, and address. Visit - stores information about each patient visit, including visit ID, patient ID (foreign key referencing Patient entity), medical record ID, clinic ID, doctor ID (foreign key referencing Staff entity), assistant nurse ID (foreign key referencing Staff entity), and visit date. Medical Record - stores information about each medical record, including medical record ID and visit ID (foreign key referencing Visit entity). Test - stores information about each test ordered by the doctor, including test ID, test name, and…
need help to draw the ERD diagram for this: Revised Entity-Relationship Diagram (ERD) Proposal: Entities and Attributes: Users: UserID [PK] Username Password (Hashed and Salted) Email ProfilePictures: (New Entity) PictureID [PK] UserID [FK] PictureData (Reference/Path to Image File) Recipes: RecipeID [PK] UserID [FK] Title Description Image (Reference/Path to Image File) Ingredients: (Potential New Entity) IngredientID [PK] RecipeID [FK] Name Quantity Unit Comments: CommentID [PK] UserID [FK] RecipeID [FK] CommentText Timestamp Relationships: Users to ProfilePictures: One-to-One Users to Recipes: One-to-Many Recipes to Ingredients: One-to-Many Users to Comments: One-to-Many Recipes to Comments: One-to-Many
Create an ERD based on the Crow’s Foot notation with Microsoft Visio, using the following business rules or requirements: An INVOICE is written by aSALEREP. Each sales representative can write many invoices, but each invoice is written by a single sales representative. The INVOICE is written for a single Customer. However, each customer can have many invoices. An INVOiCE can include many detail lines (LINE), each of which describes one product bought by the customer. The product information is stored in a PRODUCT entity. The product's vendor information is found in a VENDOR entity.
Create an entity for frequent flyer customer tracking called FFC to keep track of the customers’ flight information. If a customer has checked-in physically a flight create a transaction record with the mileage information assigned to that flight leg.
1. Which of the following represents an iterative process of systems development in which requirements are converted to a working system that is continually revised through close work between analysts and users? A. Agile Methodology B. Data Model C. Prototyping D. Rapid Application Development 2. The statement “stored representations of objects and events that have meaning and are of importance in the user’s environment” is known as ………… A. data B. database C. information D. metadata 3. The degree of relationship where VENDORS can supply various PARTS to WAREHOUSES is classified as …………… A. binary B. multinary C. ternary D. unary 4. A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is known as……….. A. database B. data warehouse C. repository D. server 5. What data type will be used to store the attribute Course for the entity STUDENT? A. Alphanumeric B. Decimal C. Float D. Integer 6. Which of the…
Can u help me to a)Mapping ERD to Relational Schema : This all data : Employee (empNo, ename, hiredate, DOB, phoneNo, gender, salary, commission, position, grade) Transaction (transactiondate, empNo, username, position) Login (ID, password) Grade (grade, salaryRange) Position (position, allowance) Allowance (allowance, allowanceDescription) Vehicle (empNo, make, model, nextMaintenance) Project (projectNo, projectName) Department (deptNo, deptName, deptDescription, totalEmpNo) Employee_Project (empNo, projectNo) Explanation: To map the ERD (Entity Relationship Diagram) to a relational schema, we need to identify the entities, relationships, and attributes in the diagram and convert them to tables, columns, and relationships in a relational database. Please need to maping as schedules By this program in the link https://youtu.be/CZTkgMoqVss U have all data only need to draw ?? Here is the relational schema for the entities provided: Employee (empno PK, ename,…
Branch(BranchNo, B_Street, B_Suburb, B_Postcode, Staff_No*, Start_Date, Monthly_Bonus, Telephone1, Telephone2, Telephone3, S_Name*) Staff(StaffNo, S_Name, S_Address, Position, Salary,Branch_No*, Supervisor_No) Property(PropNo, P_Street, P_Suburb, P_Postcode, Type, NoOfRooms, WeeklyRent, AvailableForRent, AdOnOtherWebsites, Staff_No*, S_Name*) 1. For each of these relations, write down all functional dependencies. If there are nofunctional dependencies among attributes, you must state so. Subject: MYSQL
Let's break down the information into entities, attributes, and relationships: Entities: 1. Ship - ShipID (Primary Key) - ShipName - ShipType 2. Captain - CaptainID (Primary Key) - CaptainName - CaptainLicense 3. ShipmentTrip - TripID (Primary Key) - DeparturePort - ArrivalPort - RouteDetails 4. ShipmentManifest - ManifestID (Primary Key) - Date - GoodsList 5. Goods - GoodsID (Primary Key) - GoodsName - GoodsType (BM or LM) 6. Port - PortID (Primary Key) - Street - City - State - PostalCode - Country Relationships: - Ship to ShipmentTrip (Many-to-Many): - Ship can participate in multiple ShipmentTrips, and a ShipmentTrip can involve multiple Ships. Create a junction table `Ship_ShipmentTrip` with attributes `ShipID` and `TripID`. - Captain to ShipmentTrip (Many-to-Many): - A Captain can be assigned to multiple ShipmentTrips, and a ShipmentTrip can have multiple Captains. Create a junction table `Captain_ShipmentTrip` with attributes `CaptainID` and `TripID`. - Captain to Ship…
Consider the following Staff relational schema: STAFF (STAFFNO, NAME, DOB, GENDER, DOJ, DESIGNATION, BASIC_PAY, DEPTNO) GENDER must take the Value ‘M’ or ‘F’ DEPT (DEPTNO, NAME) SKILL (SKILL_CODE, DESCRIPTION, CHARGE_OUTRATE) STAFF_SKILL (STAFFNO , SKILL_CODE) PROJECT (PROJECTNO, PNAME, START_DATE, END_DATE, BUDGET,PROJECT_MANAGER_STAFFNO) WORKS (STAFFNO, PROJECTNO, DATE_WORKED_ON, IN_TIME,OUT_TIME) i. The primary keys are underlined. Identify the foreign keys and draw schema diagram ii. Create the above mentioned tables and populate the tables iii. Note: Read all questions and populate values accordingly. iv. Include the constraints as mentioned above. v. Develop a SQL query to list the details of staff who earn less than the basic pay of all staff. vi. Create a view that keeps track of DeptNo, DeptName and number of staff in each department. vii. Develop a SQL query to list the details of staff who have more than three skills. viii. Create an index on StaffNo…
Can you draw Entity Relationship (ER) diagram based on the text. (Please use the draw.io web site for drawing.) Entity: HoneynetCentralServer Attributes: server_id (Primary Key), cronjob_interval Relationships: one-to-many with Honeypot one-to-one with LogProcessor Entity: Honeypot Attributes: honeypot_id (Primary Key), ip_address, ssh_credentials, server_id (Foreign Key) Relationships: many-to-one with HoneynetCentralServer one-to-many with LogEntry Entity: LogEntry Attributes: log_entry_id (Primary Key), timestamp, message, action_type, attack_level, honeypot_id (Foreign Key) Relationships: many-to-one with Honeypot Entity: LogProcessor Attributes: processor_id (Primary Key), rule_filters, server_id (Foreign Key) Relationships: one-to-one with HoneynetCentralServer Entity: MongoDBAtlasDatabase Attributes: database_id (Primary Key), connection_string Relationships: one-to-many with StoredLogEntry Entity: StoredLogEntry Attributes: stored_log_entry_id (Primary Key), log_entry_id…