You are an antique collector who also buys and sells antiques. You would like to

Question

You are an antique collector who also buys and sells antiques. You would like to create a computerized database to keep track of your extensive collection, some of which are quite old and expensive. You need to have accurate records/documentation in case of theft, fire or other catastrophic loss. In addition you would like to be able to generate a catalog of your collection from the database. Being an antique collector , I will need 1.a Make and state reasonable assumptions about the needs of this application, and design it accordingly 1.b. Define/describe an applicable database providing a field name, description, data type (alpha, numeric, date, logical, etc.) and size of each field. Note that the Feasibility Study has not been written so it is inappropriate to write/develop a database in response to this question. 1.c List typical reports needed by this business that would be generated from this database and specify their use. For one of the reports listed, define the report, in terms of selection criteria, sort order, data elements and use of the report.

Explanation / Answer

Here are the answers to all your questions. Please rate this.

-------------------------------------------------------------------------------

1) Since you are interested in buying and seeling the antique collections you should keep it organize and computerize which will help you in buying and selling things more quickly and efficiently.

So it is necessary to have this application

2) you can create a table in the database corresponds to your antique items.

table contains following column.

ItemId integer

ItemName varchar

Description varchar

price integer

BoughtDate date

SoldDate date

etc...

3)

different report like...

1) prices of all the items

2) availability of the items

3) sortall the items according to price

4) sort according to sold date

etc

hope this helped you

please rate

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

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