Design the database and implement it using dbms

Assignment Help Computer Networking
Reference no: EM131663030

Data and Information Management

Assessment - Managing Data in Databases

Purpose of the assessment - The purpose of this assignment is to develop skills in managing data in databases and to gain understanding of data model development and implementation using a commercially available database management system development tool.

On completion of this assignment students will be able to:
a. Model organisational information requirements using conceptual data modelling techniques.
b. Convert the conceptual data models into relational data model
c. Document the database design
d. Design the database and implement it using DBMS

Assignment Description

Established in 1854 as the Melbourne Public Library, State Library Victoria is Australia's oldest public library and one of the first free public libraries in the world.

State library founders believed that access to knowledge was critical for the development of a civil and prosperous community, and created the Library as 'the people's university' - a place of learning and discovery for all Victorians. They also charged the Library with preserving Victoria's heritage by collecting items of historical and cultural significance for future generations.

These are responsibilities that remain a critical focus today. Each year we add more than 70,000 heritage items to the Library's rich collection and lead the sector with our ambitious digitisation programs. The library also work hard to adapt and remain relevant to the Library users, as well as reach out to new audiences. As a result, Library patronage has continued to increase, with almost two million physical visits to the Library annually and over 4.3 million annual online visits.

In this project you are required to design a database for managing a library database.To fulfil the design requirement you should submit the following:

1- Describe the project and document the following requirements:
- Fully document the library database design requirement
- Draw the E-R Diagram
- Clearly set the business rules and the different type of user views
- Identify the different type of relationships used
- Clearly explain the normalisation process of the database
- Identify the functional dependencies in the library database
- Document the needed Quires, Reports and Forms used by the library
(20 Marks)

2- Implement the design using MS- Access software
- Design the reports needed for the library
- Design the needed Queries
- Design all required forms to implement your database
(20 Marks)

3- Implement the SQL commands to generate the Quires you have designed in step 2, you should write at least five SQL commands Quires

Verified Expert

Please find the enclosed answer as per the requirement. The assignment is to to create a database for a library in Access. I have considered eight tables and set the 3NF relationship. ERD is created in MS Visio. When a person issue an item from library, a unique id is generated for that person. He has to develop security as per the cost of item being issued. After returning that item, its the duty of staff members to return the security. While returning item in the library, the return date and time is saved in the database so that overdue item report can be generated when required.

Reference no: EM131663030

Questions Cloud

Managing project portfolio risks : How does emotional discipline in managing risk apply to managing project portfolio risks?
Discuss stabilize a patient with a medical emergency : Discuss specific management strategies that you might use to stabilize a patient with a medical emergency in the office setting
Deploying network security appliances : Your emphasis should relate to deploying network security appliances, using biometric technologies for network and physical security, managing organizational.
Discuss what is the ethical dilemma : Describe the decision-making model you selected from your readings, How would you resolve this dilemma using the model
Design the database and implement it using dbms : MN405 - Managing Data in Databases - Fully document the library database design requirement and Draw the E-R Diagram-explain normalisation process of database
Analysis of an ethical dilemma : Who Chooses. Who Controls. A Dialogue between Dax Cowart and Robert Burt
Describe the elements of the project plan : Describe the elements of the project plan that depend on the WBS, and provide examples of any four (4).
Common problems with project cost estimation : What are some common problems with project cost estimation? After responding to this question, provide an example from your own professional experience
Define what are some specific regulations cms : what are some specific regulations CMS Centers for Medicare and Medicaid Services or TJC

Reviews

inf1663030

1/1/2018 4:47:59 AM

My old friend recommended you guys to take help in my assignments when I need to present my first paper. Because of my friend who guided me effectively and I have quality and faultless assignments inside the predefined due date. I am thankful to Expertsmind.com for such a high-class thesis paper and extraordinary support.

inf1663030

10/10/2017 6:23:22 AM

There are some need for spelling correction and in some words spaces required .can you please correct it for me. Word file is ok. But I can't open access file.why ?.I have to submit both To open access file you must have MS-Office installed with Ms-access which is a Database comes in Ms_office package I have it.The previous access file that I made 15 days ago is opened but I don't know what's wrong with it. You send me one word file and one sql file. I can't open sql file You need to import this file in access that's how you can use it.

len1663030

9/28/2017 8:36:33 AM

Analyse Logic is clear and easy to follow. Consistency logical and convincing. Mostly consistent logical and convincing. Adequate cohesion and conviction. Arguments are confused and disjointed. Design /Presentation All elements are present and very well integrated. Most of the components present and integrated. Components present and mostly well integrated. Most components present. Report lacks structure. Evaluate/ justification Excellent outstanding effort made. Extremely good effort. Good effort made but not outstanding. Made some effort. Very little attempt. Lazy effort with inaccuracies.

len1663030

9/28/2017 8:36:26 AM

Marking criteria: Marks are allocated for each part as above: Marking Rubric for Assignment 1 –Part B: Total Marks 60 Excellent Very Good Good Satisfactory Unsatisfactory Query writing skills Evidence of accurate and well- written queries Evidence of good query writingskills. Generally relevant. Displayed reasonable query writing skills. Demonstrated little evidence of understanding the topic. Identification Demonstrated excellent ability to think critically. Demonstrated anability to think critically. Demonstrated reasonable ability to think. Demonstrated some ability to think critically but not complete. Did not demonstrate ability to think critically.

len1663030

9/28/2017 8:36:16 AM

Submission Guidelines • All work must be submitted on Moodle by the due date. • The assignment report must be in MS Word format, 1.5 spacing, 11-pt Calibri (Body) font and 2.5 cm margins on all four sides of your page with appropriate section headings. • Reference sources must be cited in the text of the report, and listed appropriately at the end in a reference list using IEEE referencing style. • The implementation of the database should be submitted separately as Ms-Access file. • If an extension of time to submit work is required, a Special Consideration Application must be submitted directly to the School's Administration Officer, in Melbourne on Level 6 or in Sydney on Level 7.

len1663030

9/28/2017 8:36:02 AM

Purpose of the assessment (with ULO Mapping) The purpose of this assignment is to develop skills in managing data in databases and to gain understanding of data model development and implementation using a commercially available database management system development tool. On completion of this assignment students will be able to: a. Model organisational information requirements using conceptual data modelling techniques. b. Convert the conceptual data models into relational data model c. Document the database design d. Design the database and implement it using DBMS Description of this assignment: This assignment consists of threeQuestions: Question 1:Describe the project and documents the requirements Question 2: Implement the design using MS- Access software Question 3: Implementing the SQL Commands

Write a Review

Computer Networking Questions & Answers

  Networking and types of networking

This assignment explains the networking features, different kinds of networks and also how they are arranged.

  National and Global economic environment and ICICI Bank

While working in an economy, it has a separate identity but cannot operate insolently.

  Ssh or openssh server services

Write about SSH or OpenSSH server services discussion questions

  Network simulation

Network simulation on Hierarchical Network Rerouting against wormhole attacks

  Small internet works

Prepare a network simulation

  Solidify the concepts of client/server computing

One-way to solidify the concepts of client/server computing and interprocess communication is to develop the requirements for a computer game which plays "Rock, Paper, Scissors" using these techniques.

  Identify the various costs associated with the deployment

Identify the various costs associated with the deployment, operation and maintenance of a mobile-access system. Identify the benefits to the various categories of user, arising from the addition of a mobile-access facility.

  Describe how the modern view of customer service

Describe how the greater reach of telecommunication networks today affects the security of resources which an organisation provides for its employees and customers.

  Technology in improving the relationship building process

Discuss the role of Technology in improving the relationship building process Do you think that the setting of a PR department may be helpful for the ISP provider? Why?

  Remote access networks and vpns

safekeeping posture of enterprise (venture) wired and wireless LANs (WLANs), steps listed in OWASP, Securing User Services, IPV4 ip address, IPV6 address format, V4 address, VPN, Deploying Voice over IP, Remote Management of Applications and Ser..

  Dns

problems of IPV, DNS server software, TCP SYN attack, Ping of Death, Land attack, Teardrop attack, Smurf attack, Fraggle attack

  Outline the difference between an intranet and an extranet

Outline the difference between an intranet and an extranet A programmer is trying to produce an applet with the display shown in Figure 1 below such that whenever one of the checkboxes is selected the label changes to indicate correctly what has..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd