ZuoTi.Pro
Question

Database Managment System Create an ER diagram that describes a retail store operation. Stores are managed...

Database Managment System

Create an ER diagram that describes a retail store operation. Stores are managed by only one Manager and a Manager manages only one store. Employees work in the stores and may work in different stores in a small geographical area. Stores are staffed with many Employees. Employees have timecards that have a startTime and endTime. Timescards are determined by the startTime and the employee SSN. The endTime for the employee and the store id also appear on the timecard, and since the store has many employees, there are many timecards for each store. Each employee receives a payStatement that is determined by datePaid and the employee SSN.   payStatements also include the amount paid.

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

se Amount cist glock Tum)

0 0
Add a comment
Know the answer?
Add Answer to:
Database Managment System Create an ER diagram that describes a retail store operation. Stores are managed...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • A company database needs to store information about employees

    A company database needs to store information about employees (identified by ssn, with salary and phone as attributes), departments (identified by dno, with dname and budget as attributes), and children of employees (with name and age as attributes) Employees work in departments; each department is managed by an employee; a child must be identified uniquely by name when the parent (who is an employee; assume that only one parent works for the company) is known. We are not interested in information...

  • Problem 1 (25 points) Consider the following database schema: Employee (fname, Iname, ssn, address, salary, mgrssn,...

    Problem 1 (25 points) Consider the following database schema: Employee (fname, Iname, ssn, address, salary, mgrssn, dnumber) Department (dname, dnumber, mgrssn, mngrstartdate) Project (pname, pnumber, plocation, dnumber) Works_On (ssn, pnumber, hours_per_week) Dependent (ssn, dependent name, bdate, relationship) The above relations store information about a company. The meaning of most of the relations and attributes is straightforward. For example, the first relation stores information about employees. The mgrssn is the SSN of the manager (supervisor) of the given employee. A manager...

  • Database Analysis and Design (ER diagram) After the requirement collection and analysis phase the software project...

    Database Analysis and Design (ER diagram) After the requirement collection and analysis phase the software project of a database application about a company is described as follows: 1. The company is organized into departments. Each department has a name, an unique number, and a particular employee who manages the department. We keep track of the start date when the employee began managing the dept. A dept may have several locations. 2. A dept controls several projects, each of which has...

  • this is database course please draw the ER by this way We have been asked to...

    this is database course please draw the ER by this way We have been asked to analyze the data requirements and develop a database system to keep information for equipment hiring companies in the country The aim of this system is to monitor the hiring of equipment to dients. There are many companies in the country, and each company has at least three branches across the country. Where each branch has staff including the branch manager who is responsible for...

  • Case Study C & S Department Store is the second largest clothing and retail store chain...

    Case Study C & S Department Store is the second largest clothing and retail store chain in Jamaica. At present, they have 5 clothing and retail stores in all 14 parishes and are planning to expand to 7 stores per parish in the next 3 years. C & S Department Store has a centralized Human Resource Department located at its main office in Kingston. Unfortunately, although the HR processes are managed centrally, there are many HR tasks, policies and procedures...

  • Would you please help me with this homework ? 1- Explain what requirements this ER diagram...

    Would you please help me with this homework ? 1- Explain what requirements this ER diagram is implementing 2- Draw an ER diagram (relationships) for the following business rules in a company: • A salesperson manages one or many other salespeople while a salesperson is managed by only one salespeople. • A salesperson can be an agent for many customers but a customer is managed by only one salesperson. • A customer can place many orders. But an order can...

  • Q1.a) Based on the business rules, you are expected to construct an Entity-Relationship (ER) diagram. The...

    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....

  • Please develop an EER Model for the following situation. Your EER diagram must be complete, meaning...

    Please develop an EER Model for the following situation. Your EER diagram must be complete, meaning that all necessary information must be presented. Make appropriate assumptions if necessary and clearly state them. The appropriateness of your assumption will be evaluated. Situation An international school of technology (IST) has hired you to create a database system to assist in its daily operation. After several interviews with the administrators, you have come up with the following list of entities, attributes, and initial...

  • Questions: 1. What trends are happening as it relates to consumer retail purchases, online vs. in-store?...

    Questions: 1. What trends are happening as it relates to consumer retail purchases, online vs. in-store? 2. What challenges do traditional retailers face in trying to transition from in-store sales to online sales? 3. List and briefly describe at least three of the strategies that Target has implemented in its staffing system to better accommodate online sales. 4. What are the career implications of the trends described in this article? 5. From a consumer perspective, what are the relative advantages...

  • DATABASE SYSTEMS Project INDIVIDUAL WORK DELIVERABLE #: SUBMISSION DATE No Group Work Allowed Apr...

    DATABASE SYSTEMS Project INDIVIDUAL WORK DELIVERABLE #: SUBMISSION DATE No Group Work Allowed April 8 Introduction to Coursework You have been approached by a University for the design and implementation of a relational database system that will provide information on the courses it offers, the academic departments that run the courses, the academic staff and the enrolled students. The system will be used mainly by the students and the academic staff. The requirement collection and analysis phase of the database...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT