answersLogoWhite

0

📱

Database Programming

Databases are collections of tables that maintain and display information, often collaboratively; this information can be used for interaction with an application or gaining general knowledge. Questions about database engines and modifying or using them belong in this category.

8,803 Questions

How can you draw a class diagram for prison management system?

how to draw a class diagram for prison Management System....?It contains mainly 3 modules

üAdministrator(Warden)

üOffice Staff

üProduction officials

This system should contain the modules like nominal roll, case register, parole register, interview requests, in-out register and a release diary generator etc.

A register will be maintained for the visitors/relatives who visit the prisoners. Arranging interviews of prisoners with their relatives/friends; Visitor management system/ tele-booking of interviews.

The administrator has setup outlet for display and sales of variety of products being manufactured in the jail factory by the inmates such as bakery products, file covers, hand made paper bags, wooden gift items, pickle, pappads, pottery items etc. These items are produced in most hygienic conditions from best available ingredients and are of excellent quality. Jail products are sold under brand names that the customers/dealers can place order and buy these products as per their orders. Also customers/dealers can submit orders for bulk purchase. So the stock and inventory of these products can be maintained using this software. Using this software the quantity, price ,type etc of each products ,customers/dealers orders ,dispatch of ordered items can be entered and maintained. Raw materials that are required for making the products are purchased using tenders and these tender/bid details are also entered and manipulated through this software.

The warden can make arrangements to educate the inmates who are interested in studies and even the public can sponsor the education of the inmates and their children if the inmates informs the warden about it. There are training programmes that include components of the correctional activities of the inmates.

There different units where the inmates are educated and then they are employed too. The different units are carpentry, weaving, tailoring, chemical, paper, pottery, show making, and baking school etc. Even fixed wages are paid to the trained inmates who are later working for the jail. Their wages details are entered and maintained by this software.

Administrator (warden) have full control over this software. After registration office staff/production officials can login and manipulate (for their assigned jobs) this software using the username and password given by the administrator.

The office staff can add, deletes and manages the details, activities of the inmates. Case registry, release registry, parole registry etc.They can also enter Missing Persons details . Similarly information of most wanted criminals etc.

The Production officials can enter the price and details of various products and their sales details (price, commodity, sale location, time etc.) The Production officials can check the product orders, order update, product delivery, update date etc through this software.

The details of Volunteers who interested in the Educational, spiritual, vocational and recreational activities for the prisoners can also be maintained through the software

Main Features:

q Case registry, release registry, parole registry ,in/out registry etc

q Missing Persons details

q Production stock update

q Order details

q Order update/sales details

q Raw materials stock update

q Fixed wages are paid to the trained inmates who are later working for the jail. Their work/wages details are entered and maintained by this software.

q Customers/dealers can place orders for the products manufactured by the inmates.

q Public can sponsor for the education of the inmates and their kids. So the sponsor details and details of sponsorship etc..

q Prior booking for telephonic conversation with inmates

q Visit Request with Inmate. The inmates' relatives/ friends can communicate with their respective inmates with the permission of the Jail warden.

q Tender /bid details.

q Information of most wanted criminals .

q Wanted Terrorists:

q Find Help and Information for Crime Victims

q Victim/Witness Complaint details

q Prison staff details ,their duty details etc

Uses of edvac?

The Electronic Discrete Variable Automatic Computer (EDVAC) was one of the earliest electronic computers, designed for performing general-purpose computing tasks. It served as a milestone in the development of modern computers by introducing concepts like stored programs and binary data processing. EDVAC played a crucial role in advancing computational research and was a precursor to the emergence of more powerful and versatile computer systems.

What questions can help identify an entity?

1- Is there more than one? An item that would need a separate table to either clarify or to hold more information.

2- Is there a variation over time? Does the information need to be changed, added to, deleted or expanded upon over the course of time.

How do I translate a SAP query report to a logon language?

SQ01 : Environment --> Languqgue comparison Put source and target language to be translated.

Choose 'Query' and put your query name with appropriate user group and press change button.

Click on the text you want to translate and press F2.

Translate it and save. Good luck.

mameepoko

What is the difference between Record and Field?

These are database terms. A field is a column in a table. (holds data). For instance, a table could be about "dress sales". Field: dress_number Field: dress_size Field: date Field: how_many_sold Record is: a row of data added to this table. Defining database fields A field is the basic unit of data entry in a record. To define a new field, you give it a name. Then you select options that determine how the fields interprets, enters, calculates, stores, and displays data. After defining a field, you can set validation, auto entry, and storage options. See Setting options for fields for more information on setting these options. Traditional databases are organized by fields, records, and files. A field is a single piece of information; a record is one complete set of fields; and a file is a collection of records. For example, a telephone book is analogous to a file. It contains a list of records, each of which consists of three fields: name, address, and telephone number.

Define the two principle integrity rules for the relational modelDisscuss why it is desirable to enforce these rules also explain how DBMS enforces these integrity rules?

Define the two principle integrity rules for the relational modelDisscuss why it is desirable to enforce these rules also explain how DBMS enforces these integrity rules?

What are the advantages and disadvantages of data recovery?

If you love your data and somehow it will lost than ??

Yes answer is DATA RECOVERY

Advantage of data recovery depend upon only one factor and that is :

Importance of data

Importance of data mean how data important for you if you work for an organization than your data should be most important and you need to recover at any cost. Data recovery software is provided by various companies like stellar phoenix.

Though data recovery you can recover your personal photo's, files and etc which is precious to you.

If we talking about disadvantage of data recovery than some data recovery companies charge high fee to recover your data if the level of corruption is so high and data not recovered by data recovery software which is one of the main disadvantage of data recovery.

Data lost can be avoided.But it is not always.So people need recover data,but not sure all the lost data can be restored.So diskgetor is the best tool.

Use schema in a sentence?

Search Engine: In an effort to improve search engines' comprehension of the attributes and details of our products, we added schema markup to our product pages.

Psychology: Based on their personal experience, the child's schema for a dog is established.

Scientific Computing: Patterns in the data set are found by the machine learning algorithm by using a sophisticated schema.

What three levels of backup may be used in database recovery management?

i. A full backup of the database, or dump of the database.

This is a complete backup of the entire database. Normally performed overnight or on weekends and usually requires that no users be connected to the database. This type of backup will take the longest time and require ample storage.

ii. A differential backup of the database.

The differential backup will back up only the data that has changed since the last full backup and that has not been backed up before. This type of backup can be done overnight (depending on the amount of data).

iii. A backup of the transaction log only.

backs up all the transaction log operations that are not reflected in a previous backup copy of the database.

Who is the author of knowledge must be speculative and not an unchangeable entity?

The quote "knowledge must be speculative and not an unchangeable entity" is from Johann Wolfgang von Goethe, a German writer, and statesman. He believed that knowledge should always be open to questioning and interpretation, rather than being seen as fixed and unchangeable.

What is a CRM database used for?

A CRM information base, which represents Client Relationship The board data set, is the groundwork of a CRM framework. Basically a focal center stores generally your client and prospect data, assisting you with overseeing communications and construct more grounded connections. Here is a breakdown of its key capabilities:

  • **Client Information Repository:** It goes about as a solitary wellspring of truth for all your client data, including contact subtleties, buy history, correspondence records, and some other pertinent information. This kills the need to follow data across dissipated bookkeeping sheets or messages.

  • **Further developed Deals and Marketing:** Outreach groups can use the CRM information base to oversee leads, track bargains, and customize outreach endeavors. Promoting groups can utilize client information to section crowds and make designated crusades.

  • **Upgraded Client Service:** By having a total client history promptly accessible, administration reps can give quicker and more productive help. They can see past collaborations and any important subtleties to address client issues successfully.

  • **Business Experiences and Reporting:** The CRM data set permits you to create reports and investigate client information. This can give important bits of knowledge into client conduct, deals patterns, and promoting effort viability, assisting you with pursuing better business choices.

  • **Coordinated effort and Communication:** A CRM encourages cooperation by giving a common stage to all groups to access and refresh client data. This guarantees everybody has the most recent data and can impart all the more successfully with clients.

Fundamentally, a CRM information base is an incredible asset that assists organizations with fortifying client connections, smooth out deals and promoting cycles, and gain important experiences to drive better business results.

What is schema?

Network+ Schema - the description of object types, or classes, and their required and optional attributes that are stored in an NOSs directory A schema is a conception perceived across all the members of a class.

Who is known as the father of database?

Dr. Edgar F. Codd is often referred to as the father of the relational model for database management. He introduced the concept in his influential paper in 1970, which laid the foundation for modern relational databases.

What type of nonfiction text type is written to retell information or to entertain?

Narrative nonfiction is written to retell information or to entertain. It presents factual information in a storytelling format, making it more engaging and enjoyable for readers. Examples include biographies, memoirs, and historical accounts.

What is second normal form and explain it with simple example?

Example: The following relation is in First Normal Form, but not Second Normal Form:

Order #CustomerContact PersonTotal1Acme WidgetsJohn Doe$134.232ABC CorporationFred Flintstone$521.243Acme WidgetsJohn Doe$1042.424Acme WidgetsJohn Doe$928.53

In the table above, the order number serves as the primary key. Notice that the customer and total amount are dependent upon the order number -- this data is specific to each order. However, the contact person is dependent upon the customer. An alternative way to accomplish this would be to create two tables:

CustomerContact PersonAcme WidgetsJohn DoeABC CorporationFred Flintstone

Order #CustomerTotal1Acme Widgets$134.232ABC Corporation$521.243Acme Widgets$1042.424Acme Widgets$928.53

The creation of two separate tables eliminates the dependency problem experienced in the previous case. In the first table, contact person is dependent upon the primary key -- customer name. The second table only includes the information unique to each order. Someone interested in the contact person for each order could obtain this information by performing a JOIN operation.

What is fragmentation in poetry?

Fragmentation in poetry is when the poem does not follow a direct narrative and drifts off in places or switches topics rapidly. Sometimes the fragmentation can take the form of cut off lines that end abruptly with a dash or an ellipses.

What is the length of a baseball field?

In Major League Baseball, the bases are 90' apart. The distance from home plate to the nearest fence is 250' or more.

If TOO MANY articles are retrieved in a database search what should be done?

To narrow down the search results, you can refine your search keywords to be more specific, use filters or advanced search options provided by the database, limit the search to certain fields or publication dates, or consult a librarian for assistance in refining your search strategy.

What are the features of a paper based form?

A paper-based form typically includes sections for inputting information, such as fields for name, address, and other relevant details. It may also have instructions for filling out the form, a unique identification number, and a signature area for authentication. Additionally, paper-based forms can be easily distributed and filled out manually.

What are some paper based organizations?

Some examples of paper-based organizations include newspapers, magazines, academic journals, and libraries that rely primarily on printed materials for communication and storage of information.

Are database can exist in paper?

A database itself cannot physically exist on paper, as it requires a digital format for storage and organization of data. However, the structure and contents of a database can be represented on paper through diagrams, schemas, and documentation. These representations help developers and users understand the database design and functionality.

What are major sources of redundancy in print?

Major sources of redundancy in print include repetitive use of words or phrases, redundant information, unnecessary details, and repetitive sentence structures. Redundancy can result in a text that is overly wordy and less clear. It is important to revise and edit print materials to eliminate redundancy and improve clarity.

What are the two characteristics of CINAHL data base?

CINAHL stands for the Cumulative Index to Nursing and Allied Health Literature. This extensive data base is fully searchable. The characteristic of this data base include a general search, and later a limiting search. This data base holds more than 2.7 million records back to 1981.

What is the description of paper based forms?

Paper-based forms are physical documents on which individuals provide information by handwriting or typing. They are typically used to collect data, gather feedback, or capture authorization from users in industries such as healthcare, finance, and government. Paper forms require manual processing and storage, and are being increasingly replaced by digital forms for efficiency and convenience.