Question

charge or more thaoe sc The manufacturing company deals with products, which are defined by Number, Name, and Unit Price. Some of the products are assembled from other products, and we need to keep information about the quantity of every product that is used for assembling of other products. 2.

ERD diagram this please

0 0
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
ERD diagram this please charge or more thaoe sc The manufacturing company deals with products, which...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

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
  • Create an Entity-Relationship Diagram (ERD). In the ERD include the following:

    Create an Entity-Relationship Diagram (ERD).In the ERD include the following: entities primary keys for all entities attributes - use "good" names for attributes, use only single-valued attributes relationships - use Crow's foot or UML notation; name relationships that could be ambiguous cardinality - minimum (optional/mandatory) and maximum (one or many) on both ends of the relationship - use reasonable assumptions if there is insufficient information in the descriptionStudent/Course registration system for a universityStudents have a unique identification number, first name, middle initial, last name, year...

  • Entity relationship diagram (ERD) question: An online food delivery company hires you to design a small...

    Entity relationship diagram (ERD) question: An online food delivery company hires you to design a small database to store information about the online orders. You’re given the following requirements: ⚫ A customer is uniquely identified by his/her email. For each customer, we also record his/her name, phone number and address. The address is composed of suburb and street. ⚫ A rider is uniquely identified by his/her ID. We will keep record of the rider’s age, gender, phone number and available...

  • Can you look and see where I could improve on this ERD and ensure that the...

    Can you look and see where I could improve on this ERD and ensure that the ERD is correct? For this task, you are to normalize the ERD that has been developed to remove any partial dependencies or transitive dependencies that may exist. Two things about customers to consider when modifying your ERD are that customers may have more than one shipping address and multiple credit cards they can use to pay for their order. Also, there are several shipping...

  • 1. A college database keeps information about: Professors- ID, Name, Title . Courses - Code, Name...

    1. A college database keeps information about: Professors- ID, Name, Title . Courses - Code, Name . Software products- Name, description For each semester, the college wants to record which professor taught which course and what software was used for it. A particular software product can be used in different courses; a professor can teach more than one course and use multiple software products; a course can be taught by different professors For each software product there is a professor...

  • ERD Diagram Based solely on the description of library operations below (without making up any additional...

    ERD Diagram Based solely on the description of library operations below (without making up any additional facts/requirements) design a data model that avoids update anomalies. You can use text to describe your model if you want. If so be clear as to what columns have primary and foreign keys, as well as what table a FK refers to. You can sketch it out on paper and scan it. You can use Visio. You can use some other tool if you...

  • Kapur Company manufactures two products: S and K. Manufacturing support costs are estimated to be RM2...

    Kapur Company manufactures two products: S and K. Manufacturing support costs are estimated to be RM2 million for the current year. Estimated unit cost and production data are as follows tems Product Product mate abor cost cost 2 per hour) 160 Estimated on units a) Required: Estimate the manufacturing cost per unit of each product if support costs are assigned to products on the traditional basis of direct labor hours Assume next that the company's manufacturing support costs can be...

  • can someone please make a relational model and an ER diagram for the following scenario. P.s...

    can someone please make a relational model and an ER diagram for the following scenario. P.s last person who made it, i couldnt read the words. I NEED IT AS SOON AS POSSIBLE PLEASE. Lets first start with the scenario, users register into the system and shares his some information as mentioned in the que. Some more information about themselves in their profile: what sort of job they do, something about their family, and what they like to watch on...

  • This is extra information about the shopping database given to answer this question: For many query...

    This is extra information about the shopping database given to answer this question: For many query questions we refer to the following database schema for a website that keeps track of what people like to buy or actually buy in different on-line supermarkets. (Think of something like a cross-store loyalty card system.) customer(cID, cName, street, city) Customers with unique cID and other attributes store(sID, sName, street, city) Stores with a unique ID and other attributes. Stores with the same name...

  • Manufacturing and Service Firms In general, firms can be divided into manufacturing and service firms. Manufacturing...

    Manufacturing and Service Firms In general, firms can be divided into manufacturing and service firms. Manufacturing firms make a tangible product. They need to determine product costs for both inventory valuation and the calculation of cost of goods sold. The cost of inventory appears on the , and the cost of goods sold appears on the . (Wholesale or retail firms purchase a product that is already manufactured. The cost of such products, which are tangible, are carried at that...

  • In Module Four, submit a systems analysis for your project, including a comprehensive entity-relationship diagram (ERD)....

    In Module Four, submit a systems analysis for your project, including a comprehensive entity-relationship diagram (ERD). Although you may use any tool to complete the ERD, it is strongly recommended that you use Microsoft Visio and then save the diagram into an image format (GIF or JPG) and then copy and paste the image into your systems analysis. All sections of this milestone should be compiled into a single Word document. Furthermore, all of Milestone One should be included in...

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