+1-415-670-9189
info@expertsmind.com
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.

Tasks:

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
Minimize
  1. user image
    len1475334

    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
    len1475334

    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
    len1475334

    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
    len1475334

    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
    len1475334

    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
Attorney is retained by one or more clients for each case, a client may have more than one attorney for each case. Determine its model.
The contents in memory occasionally have to be moved to another area of memory. When that happens, the mailbox references must be adjusted so that the program continues to
Analyze the fundamental impact of IT architecture or enterprise architecture on information management for your chosen company or industry. Determine if IT architecture impa
Must RMO consider using purchased components within new CSS? If so, When, must it begin looking for components? How will the decision to use components affect requirements,
A consultant is not necessarily a project leader, but they can only be project leader for one project. Draw an entity relationship model for the project management System.
A detailed description of both functional and nonfunctional requirements. At least four (4) functional requirements and four (4) nonfunctional requirements should be provide
Describe the waterfall methodology and identify its relationship to the PMBOK® process groups. Describe the agile methodology and identify its relationship to the PMBOK® proce
Explain advantages and disadvantages of implementing a DFS for this size of company, along with a recommendation for or against, and why.