HomeworkLib
Question

Draw an EDR to describe a database to record and control inventory for the Bovil Bow...

  1. Draw an EDR to describe a database to record and control inventory for the Bovil Bow and Arrow Factory. Include a data dictionary.

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

Homework Answers

Answer #1

ANSWER:

TO construct the EDR I have taken the simple approach to design the EDR.

Which contains the simple Inventory, which should contain

  1. manufacture
  2. imported items Details
  3. items manufactured
  4. orders that have been placed
  5. customers info
  6. And Catalog

Orders info should contain the shipping time, details, delivery time, etc.

Customer info should contain, address , paid time etc.

Here is my ERD

0 0
Add a comment
Know the answer?
Add Answer to:
Draw an EDR to describe a database to record and control inventory for the Bovil Bow...
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

  • database

    The Papa Car Service & Repair Centers are owned by the Silent Car Dealership; Papa services and repairs only silent cars. Three Papa centers provide service and repair for the entire state.  Each of the three centers is independently managed and operated by a shop manager, a receptionist, and at least eight mechanics. Each center maintains a fully stocked parts inventory.  Each center also maintains a manual file system in which each car’s maintenance history is kept: repairs made, parts used, costs,...

  • This is questions of Accounting Information Systems 1) Fo a database. Each row in this spreadsheet...

    This is questions of Accounting Information Systems 1) Fo a database. Each row in this spreadsheet represents a: ur Tet Industries tracks customer information using various Microsoft Excel spreadsheets stored in a. Field b. Record c. File d. Database 2) A d tables is a. What is the correct term for the database field in Table 1? latabase field in Table 1 that serves as a unique identifier in Table 2 and is used to link both of the a....

  • Draw the database system environment and describe the main characteristics of using this environment (or approach)?

    Draw the database system environment and describe the main characteristics of using this environment (or approach)?

  • Define what a relational database is. Describe its importance to an organization and why securing it...

    Define what a relational database is. Describe its importance to an organization and why securing it is important. Provide a database schema in tabular format and provide the necessary SQL statements to build it. Your database should include a table with a minimum of three attributes (columns). Include the SQL statement to create the table and insert data into three rows of the table. This is an individual assignment.

  • Describe the rationale for what business problems your database can solve for your company my company...

    Describe the rationale for what business problems your database can solve for your company my company is TESLA · Illustrate 4 different examples in which data from your database can be used with analytic techniques to support operational decisions and competitive advantage · Include a discussion of how this would differ or be similar to applying mining techniques to your data.

  • Describe the inventory control methods used at Scotiabank. In your answer describe which goods are being...

    Describe the inventory control methods used at Scotiabank. In your answer describe which goods are being inventoried (inputs, finished goods, etc.), how often the goods are reordered, and where they are ordered from.

  • Topic: Inventory Manangement Part A. Database Creation Your database should have a minimum of 4 tables...

    Topic: Inventory Manangement Part A. Database Creation Your database should have a minimum of 4 tables and include both one-to-many and many-to-many relationships. Be sure to include some numeric and/or date fields. Define all appropriate constraints, using the proper naming conventions (see Structure Notes below). Populate your database with at least 30 records in the main table(s), and whatever is needed in related tables. Submit the following: • a short description of the purpose of the database and what the...

  • PART I – SQL Data Control Language and Views: The users of the Medical database include...

    PART I – SQL Data Control Language and Views: The users of the Medical database include three nurses (nurse_1, nurse_2, and nurse_3), three physicians (doc_1, doc_2, and doc_3), and one manager (manager_1), all of whom have been created by the DBA. You are asked to use SQL to create necessary roles and grant the indicated privileges to roles/users. Medical DB Schema Diagram

  • Help with this assignment for database systems course : Draw the entities and relationships suggested by...

    Help with this assignment for database systems course : Draw the entities and relationships suggested by each word problem.  Include the proper foreign key(s). Remember to make a copy for yourself.   Unary Relationships 3- Employees (Empid, name) can mentor other employees, or not.  Every employee has a single mentor. Mentors only have one person that they mentor at a time (a mentee).  When they get a new mentee we just overwrite the record of the previous mentee. 4- Same as...

  • Record the journal entries for the following transactions during 2020 Bow AutoSave | OFF Review Data...

    Record the journal entries for the following transactions during 2020 Bow AutoSave | OFF Review Data View Tell me Home Insert Draw Formulas Page Layout A A y Wrap Text Paste B TU Uv CA Merge & Center M B4 Xfx =E_3 1 K G L А с H B D E F 1 Entry Bowers Inc.'s transactions during 2020: 21 On Jan 1, Bowers Inc.pays cash of $1,605 towards their Accounts Payable. 382 On Jan 15, Bowers Inc. purchases...

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