Project- Database system design for college library Need help with- Fields speci

Question

Project- Database system design for college library
Need help with- Fields specification forms( As many forms possible) for college library

Field Specifications General Elements Speofication Typa Unique Genaric Raplics Shared by Physical Elements Data Typ Decimal Places Input Mask Display Format Character Support Numbers 10-9)__. Special(O™@? Logical Elements Key Type None:__ Edit Rule Primary:_ Faraigt--Ansmate: nter Now, Edats Allowed Enter ow, Edis No Allowed Enter Laler, Edits Aluwed ner Later, áts Nat Alowad Not Detemmised at this time. Nulls Allowed Byssem Alowed Oeser Flelds Value Expression All Operations Alowed Value ExpressionAL

Explanation / Answer

For a  Database system design for college library, the required Forms can be distinguished as follows:

1. Keep the record of different categories of entities like; Books, Journals, Newspapers, Magazines, etc.

2. Classify the books as per the subject wise.

3. Easy way to enter new books into the table.

4. Keep the record of complete information of each book like; Book name, Author name, Publisher’s name, Date/ Year of publication, Cost of the book, Book purchasing date or the Bill no etc.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

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