Essay on Database - 2414 Words

Project on Database Design for College Library Index: 1. Introduction............................................................................ 3 2. Requirement Analysis ..............................................................4 3. Defining Entitiy and Attribute...................................................5 4. Entity Relationship Diagram......................................................6 5. Non- Technical overview of Entity Relationship Diagram..........7 6. User Applications...................................................................... 7 7. ER†¦show more content†¦SQL Queries to retrieve data .........................................................29-37 11.Factors that influence Physical Database Design.............................38 Introduction : Generally Institutions are mature and different systems are employed by the libraries to manage their resources in an efficient manner but still many libraries remain unconvinced and show reluctance to employ and switch over to new systems. Library management refers to the issues involved in managing the resources available in library such as classification of material, book processing, Journals. My plan in implementing database design for college library will bring out technical advantages that are lacking in present system in maintaining Library.I will analyse the limitations of existing manual system employed by a college library and will mainly focus on the solution to provide a centralised repositoryShow MoreRelatedDatabase And Database Management System Essay1068 Words   |  5 PagesZalgaonkir Pearson Cape Town Campus Introduction to Databases project Student Number: MB2014-0413 Teacher: Andrew Davies Due Date: 23/09/2016 2 Contents Page Page 1†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦..Cover Page Page 2†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Contents Page Page 3-5†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦.Question 1 Page 6-12†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Optional Access Screenshots Page 13-18†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦.Question 2 Page 19†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦References and Bibliography 3 Question 1 1.1) Database Database is defined as a set of related data in many tables andRead MoreRelational Database : A Database1622 Words   |  7 Pages Relational Database Introduction – What is a relational database It is a database which shows the links and relationships between two sets of data/stored information in a document or mainly entities. This means e.g. if a computer system has to store a lot of data/information about people instead of repeating the same row of information which may include personal or unnecessary things, you will then be able to click on the main primary key data which then leads to the actual personal things. ThisRead MoreDatabase Security And Concerns Of A Compromised Database894 Words   |  4 PagesDatabase Security and Concerns In today’s world, there is a growing amount of complexity when it comes to databases. With that growing complexity, an increasing amount of security concerns arise, such as: unauthorized access and SQL injection. SQL injection is used to attack data-driven applications. SQL injections can manipulate or destroy databases depending on its purpose. Due to the security breaches, measures are constantly put in place in order to prevent anymore from happening. This paper’sRead MoreQuestions On Database Security And Database Systems1368 Words   |  6 PagesDATABASE SECURITY Submitted to the Faculty of American Public University By Loren Robert Hensley In Partial Fulfillment of the Requirements for the Course of INFO620 Enterprise Database Systems November 2014 American Public University Charles Town, WV â€Æ' Abstract This paper explores the different aspects of security as it pertains to database systems. It will provide an overview of security concerns such as access control, user authentication, reliability and data integrity, as well as how IT professionalsRead MoreDatabase Indexes : Database Index2068 Words   |  9 Pages Database Indexes Akhila Mupparaju Wilmington University IST-7000 April 23, 2015 Sten David. Database Indexes A Database, support query optimization technique (Jeffery A. Hoffer, V. Ramesh, Heikki Topi, 2010). An index is a pointer to the data in a table, and it is an access mechanism that helps to find out where a record present. A database can have one or more indexes connected with it. A database index is one type of data structure, it is usedRead MoreTypes Of Database For Flat File Database939 Words   |  4 PagesTypes of Database 1. Flat File Database A flat file database is an excellent way of storing a pretty small amount of records. Flat file can be a plain text file. Flat file are generally not a structural relationships between the records. For example a spread sheet application such as Excel can be used as a flat file database. Each row in a worksheet can be a record and each column and a field. Flat file database can also be stored in a dedicated database application such as Access. Installing databaseRead MoreDatabase Management System : History Database System1408 Words   |  6 PagesDATABASE MANAGEMENT SYSTEM History of database system: Brief history of database management is as follows, 1950s: Database management system started its journey in late 1950s with the invent of magnetic tapes. All the data was stored in tapes. Processing of data requires reading data from one or more tapes and writing to a new tape after processing. 1960s – 1970s: Database management system could enhance its features with invent of harddisk. Unlike files, hard disk supports random accessRead MoreTechnical Guide : Database And Database Essay1551 Words   |  7 PagesTechnical guide Database It is the collection of schemas, tables, queries, reports, views, and other objects. The data are typically organized to model aspects of reality in a way that supports processes requiring information, such as modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies. It is a structured set of data held in a computer, especially one that is accessible in various ways. A database is a collection of information that is organized soRead MoreRelational Databases4819 Words   |  20 PagesCHAPTER 4 RELATIONAL DATABASES SUGGESTED ANSWERS TO DISCUSSION QUESTIONS 4.1 Contrast the logical and the physical view of data and discuss why separate views are necessary in database applications. Describe which perspective is most useful for each of the following employees: a programmer, a manager, and an internal auditor. How will understanding logical data structures assist you when designing and using database systems?lt;/paragt;lt;/questiongt;lt;questionRead MoreRelational Database : Assignment : Database1882 Words   |  8 PagesRelational Database – Assignment Introduction – What is a relational database It is a database which shows the links and relationships between two sets of data/stored information in a document or mainly entities. This means e.g. if a computer system has to store a lot of data/information about people instead of repeating the same row of information which may include personal or unnecessary things, you will then be able to click on the main primary key data which then leads to the actual personal