Converting the conceptual model to logical schema

Assignment Help Database Management System
Reference no: EM132267881

Individual Report

You may choose any one topic based on the organizations (may not be a real company) given below. You should get approval from the Lecturer before starting the assignment

• Hospitality Industry - Database for Restaurant or Hotel,
• Health and medical Industry - Database Hospital, Clinic, Pharmacy
• Government Agency - Database for Ministry Departments
• Tour and Travel - Database for Airline Ticket Booking, Bus Ticket, car Rental,
• Academics and Education - Database for College, University
• Retail - Database for Inventory system and retail shop
• Finance - Database Insurance Company or Banking

*Selected - Database of construction company.

Each of these sections is described below in more details.

1. Initial Study

The goal of this phase is essentially to gather the company details and its business processes. The company details should be gathered in terms of name, location, when was it started, what is their main business? The details of business and/or operational processes used by the organization should be provided. Details on what the company wishes to accomplish, what problems and limitations users have, what is the new database system have to do, and in what way must it be done should also be given. The initial study should also include scope of the database.

2. Requirements gathering & analysis

In the requirements gathering & analysis phase, the requirements collected and analyzed. The collected requirements help to understand the system that does not yet exist. The purpose of the requirement analysis is to identify and describe the data that are used by the processes of the organization.

In this section you should use and document different methods like interview, questionnaire, observation, reading company documents and reports. The purpose of these methods is to gather all the information needs of users involved in or affected by the business process. The documentation for the interview should include the details of the interviewee, the questions asked, and the response. The documentation for the questionnaire should include the analysis of questions which make use of some data. Documentation for the observation and reading documents should include data used by the processes.

At the end required entities should be documented and relationship matrix should be given to depict the relationship between entities.

3. Design

In this phase, the conceptual models and logical model has to be developed based on the requirement gathering & analysis. In conceptual schema design, the data requirements collected in requirement gathering & analysis phase are examined and a conceptual database schema is produced. The conceptual schema is then translated into the logical model and normalized.

Modeling the requirement using the E/R conceptual model

A data modeling phase involves modeling the database structure itself by using a method such as entity relationship diagramming (ER diagram). This provides a means of visually representing various aspects of the database structure, such as the tables, table relationships and relationship characteristics.

In this section you need to determine entities about which information is to be maintained, determine the properties or characteristics of those entities, determine the relationships between entities. Draw the entity relationship diagram using the Crow's Foot notation. You should draw the E-R diagram in Visio 2013. You should include all attributes for each entity and the relationship with cardinality and all keys must be properly documented. Your E-R diagram should have minimum of five to six entities.

Data Dictionary

In this section you need to produce the data dictionary for each Entity. The data dictionary should include name of the attribute, type, size, domain, description. The data dictionary should also include information on keys and constraints such as whether the specified attribute is a primary key, foreign key, unique, not null and whether there is any condition to check using the check constraint. The data dictionary section must be supported with proper explanation and justification. The explanation must include criteria of considering PK and other constraints.

Converting the conceptual model to logical schema

In this section you should convert your E-R diagram to logical/relational schema. Use the proper rules to transform 1:1, 1: M/M: 1 and M: N to logical schema. You should underline the primary keys and put an asterisk for foreign keys.

Normalizing the logical schema

The Normalization phase is the process of decomposing large tables into smaller tables in order to eliminate redundant data and avoid problems with inserting, modifying or deleting data. Table structures are tested against normal forms, which are a specific set of rules that can be used to test a table structure to be sure it is sound and free of problems.

You need to check your produced Relational Schema above for 1NF, 2NF and 3NF.If it satisfies 1NF/2NF/3NF criteria then you ONLY need to include the statement "The Relational Schema satisfies 1NF/2NF/3NF criteria". If your schema does not satisfy the criteria of 1NF/2NF/3NF then you need to reproduce your schema in 1NF/2NF/3NF.The conversion should be documented.

Attachment:- DBMS-ASSIGNMENT.rar

Reference no: EM132267881

Questions Cloud

Which office contains the health-related data : Healthcare data at a community, county, or region level and state level determine healthcare spending and services allocated for individuals.
Every auction the auctioneer is the person making the offer : Offers to sell an item on sights such as Ebay are always bidding on the seller. In every auction the auctioneer is the person making the offer.
Why do some executives refuse to function : Is it right for the sponsor to be the ultimate person responsible for the success or failure of the project?
Explain the place of profession in the healthcare system : Explain the place of this profession in the healthcare system. Is it in diagnosis, treatment, rehabilitation, etc.? Some professions will embrace all of these.
Converting the conceptual model to logical schema : CC12-2 Database Management Systems - MAJAN UNIVERSITY COLLEGE - identify and describe the data that are used by the processes of the organization
Differentiate between leadership and management roles : Differentiate between leadership and management roles, and provide specific examples from the text, literature, or personal example.
Goal of developing collective bargaining agreement : students to have the opportunity to role-play an actual negotiation session with the goal of developing a collective bargaining agreement.
Assess the ethicality of the organization : Assess how, and to what extent, corporate social responsibility can be coordinated with an organization's obligation to maximize profits for its shareholders.
Lawsuit is finally decided between the parties to the suit : Red Judicata means that when a court issues a final judgment, the subject matter of that lawsuit is finally decided between the parties to the suit.

Reviews

len2267881

3/27/2019 9:27:30 PM

D+ 7 Pass • Satisfactory. • Shows sufficient grasp of the subject to be acceptable. • Tends to be descriptive. • Examples and evidence is likely to be weak and limited. • Shows limited reading. • Referencing is likely to be absent or very poorly carried out.

len2267881

3/27/2019 9:27:23 PM

C+ 10 Good • Generally good work. • Most points will have been covered, but many finer points will generally have been missed. • Shows limited reading. • Arguments/analysis should be basically well structured and balanced with relevant examples, but with errors and gaps. • The writing is clear, but has errors that nevertheless do not obscure the meaning. • Referencing will be present but may at times be inaccurate or insufficient.

len2267881

3/27/2019 9:27:14 PM

GRADE GRADE POINT DESCRIPTION GENERAL ASSESSMENT CRITERIA A+ 16 Excellent • An outstanding piece of work. • Shows evidence of wider reading and originality • Strongly analytical. All important points are covered. • Arguments should be supported by examples and evidence, objectively presented and evaluated, • Well-structured and well written, without noticeable grammatical or other errors. • Correctly referenced

len2267881

3/27/2019 9:27:06 PM

• The Lecturers will consider a number of factors such as Assignment type, Part of the assignment where similarity occurs, Nature of similarity etc., along with the similarity percentage of your assignment, to assess the originality of your assignment. Therefore, similarity percentage would not be accepted as a basis for disputing academic judgments regarding plagiarism. • Note that the similarity percentage of your submission can change till the submission deadline, if the submissions of other students have similarity to your assignment. Therefore, the similarity percentages are not final, till the assignment submission is closed.

len2267881

3/27/2019 9:27:00 PM

• The last submission, within the deadline, will be considered as your final submission. • The similarity percentage of your final submission will be one of the factors considered, for assessing the originality of your assignment. However, the decision to report an assignment for plagiarism is taken by the Lecturers, who mark your assignment.

len2267881

3/27/2019 9:26:52 PM

Additional Guidelines • The Assignment Submission link on MOVE will be open, a week ahead of the submission date. • You can submit your assignment multiple times, till the submission deadline. Note that Turnitin could take up to 24 hours to produce similarity reports for submissions. • Assignments should be submitted by 6pm on the day of the deadline. There is a grace period until midnight to allow for any technical difficulties, but any assignments submitted after this will be counted as late. Technical problems will not be accepted as an excuse for submitting after the day of the deadline

len2267881

3/27/2019 9:26:43 PM

8. The cover page should be attached with the assignment and uploaded through MOVE (on- line. Name of the student, The Programme, Module Title and Assignment Title reflected on the cover sheet. 9. All assignments must be adhered strictly to the deadlines specified by Majan College. Failure to hand in the assignment for any reason and without prior approval and a valid written extension from the module tutor will not be marked and will be awarded a grade G (0) irrespective of the quality of the work. See Student handbook page 16 section 4.4.

len2267881

3/27/2019 9:26:36 PM

6. This assignment carries 50% weighting toward final grades. 7. This assignment follows a design format and must be original and creative. An analytical piece of work is required. The use of ‘cut and paste’ approach will be penalized. It must be presented in a structured manner, with appropriate cover page, content page, introduction, body (with appropriate heading / sub-headings), conclusion, references, page numbered and any required appendices.

len2267881

3/27/2019 9:26:32 PM

Your work will be graded on the following aspects: 1. This is an Individual Assignment. 2. The assignment MUST be submitted online (through MOVE) in Week 9. 3. Your assignment shall reflect the depth and breadth of your original analyses in a clear and coherent manner. 4. Use of the relevant academic literature to support ideas and issues discussed. The range of academic sources such as texts and journals to support your arguments and comments. 5. Any reference to authors and other writers shall be quoted with due acknowledgement in your assignment report using the Harvard Referencing System. For details of Harvard referencing style refer the student’s hand book page 46 sections 7.2.

len2267881

3/27/2019 9:26:16 PM

3.2 Data Dictionary 500 • Must be supported with proper explanation and justification. • Must be placed as a screenshot image in the report to avoid the content high similarity. 3.3 Converting the conceptual model to logical schema 500 Must be supported with proper explanation and justification 3.4 Normalizing the logical schema 500 Must be supported with proper explanation and justification

len2267881

3/27/2019 9:26:10 PM

Section No. Sections Name Approximate No. of Words Remarks 1 Initial Study 250 Must be explained in details 2 Requirements analysis 500 Must be explained in details 3 Design: 3.1 Modelling the requirement using the E/R conceptual model 250 • Entities must be identified inline to the requirements. • The attributes must be well identified for each entity.

len2267881

3/27/2019 9:26:02 PM

Assessment 1 is an individual report. The assessment contributes 50% towards the overall grade. This assignment will assess your ability to design and develop a small-scale database system. Your database should, if possible be a real one. Alternatively, you may create a simulated real world database based on information requirements in an organization with which you are familiar. The length of assignment should be 2500 words +/- 10%. The overall task of this assessment, is to write an individual report that describes a complete database structure with all its related components based on a selected topic.

len2267881

3/27/2019 9:25:55 PM

Please note that a grade will only be given to those whose student number is noted on this form. Please ensure that the student numbers from all group members are recorded accurately. • The work contained in this assignment is my own and that all materials and sources used have been acknowledged. • I/We have not copied or colluded in part or in whole, or otherwise plagiarised the work of other students. • This assignment has not been submitted for previous assessment in any other subject or to a substantial extent has been accepted for the award of any other unit, module, degree or diploma of a university or any other institute, except where due acknowledgement is made in the text.

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