Create eer logical model assessment

Assignment Help Database Management System
Reference no: EM133118706

ICTDBS506 Design Database - WIN College

Assessment Task - Create EER Logical Model

Simulated Workplace Case Study -Library System

Consider the following description for a Library Information System:

A library needs to keep records of current loans of copies of books to borrowers and reservations for book titles.

Each borrower is identified by a BORROWER# and each copy of a book title in the library is identified by an ACCESS# as the library may have more than one copy of a given book title.

The NAME and ADDRESS of each borrower is held so that communications such as overdue loan reminders can be sent when necessary.

The information required about book titles is TITLE, AUTHORS, PUBLISHERS, PUBLICATION DATE, and ISBN.

For individual copies of a book title the PURCHASE PRICE and CURRENT PRICE are required, where purchase price is the price the library paid at the time of purchase and current price is the current listed price charged to borrowers who lose books. ISBN is an internationally used identifier for a book title.

A borrower may have any number of books out on loan at any one time, but a book may be borrowed by only one borrower at a time.

The DUE DATE for each loan is recorded so that overdue notices can be sent out. Book titles out on loan may be reserved by other borrowers pending their return.

Borrowers may make a reservation for only one book title at a time. Reservations for a book title are processed in order of the date the reservation was made as copies are returned.

You can use a MySQL Database - MAMP (which is universal for Apple and PC) as well as use Workbench to create a EER diagram.

Task - Create EER Logical Model

1. Identify and report on attributes and determine data types that are required for your database ensuring that you undertake normalisation of the attributes.

2. Develop an EER/Logical Model Design using Workbench for the Library system and clarify cardinality of relationships. Workbench can be used to create the physical model.

3. Document your attributes, normalised data and EER diagram

4. Submit to your Trainer to seek feedback and obtain approval. Make changes according to feedback - if required.

5. Confirm primary and foreign keys according to database/technical requirements analysis from A2.

6. Identify referential integrity constraints and organisational business rules.

7. Establish database management system constraints and incorporate into database design using Workbench software.

8. Design and develop data validation rules, indexes.

9. Document database design according to organisational policies and procedures.

10. Design database according to organisational requirements - this will be created from within Workbench from the ERD model created in this assessment.

11. Forward Engineer the Model in Workbench into .sql file to backup Database. Save to your computer.

12. Import your database into MAMP.

13. Incorporate data into your database e.g., user information and other information from your findings in A2.

14. Download the data Dictionary and submit with this assessment task.

Specifications

What you have to Submit/Upload;

Task 1

1. Report on the attributes and the data types and normalisation of attributes that are required for your database - This Assessment Task

Task 2

2. Create your EER Logical Data Model
3. Obtain Feedback for ERD Diagram from Trainer and make changes according to feedback comments.
4. Identify Referential Integrity restraints and business rules - This Assessment Task.
5. Data Dictionary

Task 3

6. Answers to these all the questions uploaded to A3 in Moodle/Learn under A3 Assessment Submission

Attachment:- Create EER Logical Model.rar

Reference no: EM133118706

Questions Cloud

Calculate or state the net book value of greenachine : alculate or state the net book value of Greenachine for the financial year-ended 31 December 2021 of Energee Malaysia Berhad (EMB)
What is the current market price of the bonds : The current market rate of interest on the Fresh Water, Inc. bonds is 10.67 percent. What is the current market price of the bonds
Future value interest factor : You have won a total of $75,000.00 from a contest participating in a reality television program. The prize money will be used to make future investments and tha
What is total contribution margin : Schister Systems uses the following data in its Cost-Volume-Profit analyses: Total Sales $325,000. What is total contribution margin
Create eer logical model assessment : Create EER Logical Model Assessment - Identify and report on attributes and determine data types that are required for your database ensuring
What are the net borrowing costs for a and b : Consider two corporations A and B. A, a high-quality borrower, wishes to raise $50 million in five-year floating rate funding. The company can borrow fixed rate
Interest rate on the three-year bond : If the expected path of one-year interest rates over the next three years is 4%, I%, and l %, then the expectations theory predicts that today's interest rate o
Create uml and conceptual model : Create UML and Conceptual Model - Determine the user-needs analysis for the technical requirements and report your findings
Differentiate between fixed and variable costs : In what types of decisions can break-even analysis help managers? Differentiate between fixed and variable costs.

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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