Design a database to manage the parts in an electrical system. The database shou

Question

Design a database to manage the parts in an electrical system. The database should store the following fields: Part Description (string) Part Number (string) Quantity (integer) Vendor (string) Cost (float) The user should be able to enter a new record. When entering a record the user should be prompted for each individual field. The data stored in the database should be able to be displayed to the screen. When displaying the data, the user should be able to choose which field should be used to sort the data. The user should be able to be given a tally of how much the project will cost. When running the program, a menu should be presented, giving the user options to view the data, enter a new record, delete a record, or quit the program. After a menu choice is selected, the action selected should be carried out and the menu presented again (unless quit is chosen).

Explanation / Answer

a table for electrical system should be created with fields mentioned below:

part desc string not null

part number string not null primary key

quantity integer not null

vendor string not null

cost float not null

the part number should be made the primary key for the database to select and sort the rows as per the user requirement.

The design of the db is such that we can sort based on individual keys.

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.