Critically compare different data models
Course:- Software Engineering
Reference No.:- EM131475334

Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
Assignment Help >> Software Engineering

Learning outcomes

1. Understand the database concepts and components
2 Develop a logical database design.
3 Implement a physical database for a given requirement
4 Test and document databases

Scenario and the Task

The Institute of PG Technology has the biggest library in Newplymouth. Currently it has about 200 members. Currently all the functions of the library are done manually. They have plan to expand the library by adding new sections so now management has planned to automate the library management system, in order to provide its members better services to reduce the work load of the staff.

Assume that you are the database engineer of Creative Vision information technology (IT) services, company providing IT solutions worldwide. Now they are developing automated library system for a The Institute of PG Technology. As a data base engineer your responsibility is to design and implement a robust Database System for above mentioned library.

Library has different units such as computing, management, English etc. There are number of books under different categories. There are number of book copies for one book (book title).Any person who joins The Institute of PG Technologycan become a member buy paying member fee.

After doing the fact finding part development team has identified that below mentioned information's to be stored in the system.
Author's information such as author id, first name last name, contact information, and publishers information Pub id, Name, Street, City. Unit is identified by unit id, unit description is stored in the system. Category id and name, Book title should contains Call number, Title, Price, and Availability (y or n) as its attributes. Member should have Member id, Name, City, Member type, Member date (date of membership), Expiry date. Member can borrow book copy issue date and return date should be mentioned for specific member. Member can reserve book title request date and ref number is mentioned for that member. Book copy contains access id and edition

Students can add any functionality which will enhance the system and make the proposed solution more comprehensive.

Use Harvard referencing to properly acknowledge all the external sources you use.


Design the database with the constraint that the available technology is relational.

1. Explain what is data model, Critically compare different data models and explain why older data models are being replaced by new data models.

2. Critically explain the benefits and limitations of different database technologies.

3. Analyze and briefly explain the different approaches to database design.

4. Draw an entity relationship diagram for given scenario with proper standards. Identify important keys and represent different types of attributes and relationships.

5. Draw Relational Schemas. Effectively map conceptual data models with relational database schema according to the mapping algorithm. All the steps should be clearly mentioned.

6. Create the database using SQL server. Practical submission and Demonstration

7. Write 10 sql queries for given requirements using SELECT Statements. Practical submission and Demonstration

8. Generate the suitable management reports for database by using graphical format.

9. Explain the purpose and benefits of having queries in the database for construction firms' decision making process with the examples.

10. Provide the Test plan, test strategy and proper test cases and provide all the test documents.

11. Create the user manual for the database.

12. Explain how verification and validation has addressed in your data base and the access rights to various types of users.

13. Provide a well-structured documentation including proper academic style and Referencing and in-text citation using Harvard Referencing System.

Put your comment
View Conversion
  1. user image

    Guidelines for the report format Paper A4 Margins 1.5” left, 1” right, top and bottom Page numbers – bottom, right Line spacing 1.5 Font Headings 14pt, Bold Normal 12pt Font face- Times New Roman Referencing and in-text citation should be done strictly using Harvard Referencing System.

  2. user image

    This submission will be assessed as follows Total marks Allocated Marks obtained by the student for the answer provided TASK 1 10 TASK 2 5 TASK 3 5 TASK 4 10 TASK 5 10 TASK 6 10 TASK 7 5 TASK 8 5 TASK 9 10 TASK 10 10 TASK 11 5 TASK 12 5 TASK 13 10

  3. user image

    TASK 12 Clearly explain the applied verification and validation process in the data base and explain the Object permission, Statement permission and Implied permission Statements TASK 13 Well-structured Documentation with proper formatting styles and Harvard Referencing System is used for Referencing and in-text citation.

  4. user image

    TASK 5 Relational Schema for ERD state the primary key foreign key concept correctly (Proper theories and techniques need to apply in Relational schema) TASK 6 Create Database using SQL server TASK 7 Produce SQL queries for manipulation functions TASK 8 Produce Management Reports with Quarries which assist managers in making decision and using MS SQL Report builder tool TASK 9 Clearly explain the purpose and benefits of having queries in the database TASK 10 Correct Test plan and test cases with all test documents TASK 11 User-friendly descriptive user manual (Logical flow of contents in the document, descriptive user manual.)

  5. user image

    TASK 1 Compare Hierarchical , Network and Relational data model and the importance of adapting a new data model TASK 2 Compare different database technologies SQL server, Oracle, MySQL TASK 3 Top down design method, Bottom-up design method, Centralized design and De centralized design TASK 4 ERD with cardinality and attributes with proper standard symbols (Proper theories and techniques need to apply in ERD) . Use Chen & Martin notations for ERD

Ask Question & Get Answers from Experts
Browse some more (Software Engineering) Materials
CSC-580 Spring 2016. 1) For the Ticket Kiosk System, develop: a) Four (4) associations, b) Two (2) dependencies And 2) For the Integrated Home Entertainment System, develo
This assignment will give you the opportunity to provide a backup strategy and disaster recovery plan to protect the organization against disruptions to the availability of
SOFT251: Object Oriented Programming Assignment. You are required to produce a Java desktop application OR a Java web application that meets the universities requirement spec
Design an entity relationship diagram for the case, explaining any suppositions you deem essential for atered or non-catered accommodation at the centre.
CSC-580 Software Engineering Spring 2016. Zachman Framework: Develop the Scope portion of the Framework: Pay close attention to the What (Data) and How (functions) sections
Define a class called Counter. An object of this class is used to count things so it records a count that is a non-negative whole number. Include methods to set the counter
Write down the main ideas behind relational model? Why are they an improvement over what came before? In what ways is the relational model restrictive?
Assume that you are approaching the implementation and deployment phases of the online course management system that you worked on in previous assignments. Imagine that the cl