Ask a question from expert
Database Systems and Design - PDF
28 Pages1779 Words95 Views
Added on 2020-12-24
Database Systems and Design - PDF
Added on 2020-12-24
BookmarkShareRelated Documents
Database Systems and Design
Table of ContentsINTRODUCTION...........................................................................................................................3TASK 1............................................................................................................................................31.1 Select the specific situation based on the company and design the database design ............31.2 Create Entity relationship diagram and shows all entities, attributes and weak or strongentity. ..........................................................................................................................................4TASK 2............................................................................................................................................52.1 provide logical database design according to the scenario....................................................52.2 Create database tables using Oracle DBMS..........................................................................6Department table-.........................................................................................................................72.3 create most useful indexes on the tables..............................................................................112.4 Data population....................................................................................................................122.5 SQL Query language............................................................................................................15CONCLUSION..............................................................................................................................21
INTRODUCTIONDatabase management system is basically the collection of information that store in theform DBMS. It allows for manipulate, retrieve and store the data within the database system.This report will discuss about the database that design by using oracle DBMS. This tool isdesigned for the data that contain the transaction management, schema objects and relationbetween the entities. This assignment will describe about the logical scenario of company tomanage their business operations and functions with the help of database management system. TASK 11.1 Select the specific situation based on the company and design the database design Company scenario-According to scenario, it is used the manufacture organization which based on themanufacture company to sell their product and service in marketplace. Each and everydepartment has performed their specific task to maintain the facilities in proper manner. All theemployee connected to the project and work on particular task in proper manner (Abadi andFaleiro, 2018). On the other hand, Mechanics and sales man has been connected with the productof company and both performed different task whereas mechanics repair the car or salesman sellthe car in marketplace. This entire operations and function is managed with the help of databasesystem. Relevant background information in the organization:A manufacture company is performed different operations and functions such as sellingthe product and repair car in proper manner. Each and every employees are connected with thedepartment plays different role in proper manner. The basic aim of this firm to provide thefacilities to their customer to repair their car in proper manner. Operation supported-It supported to sell the products, maintenance of car etc.
1.2 Create Entity relationship diagram and shows all entities, attributes and weak or strongentity. Entity relationship diagram is basically the data modelling technique that representing theinformation with the help of different entities and their specific relationship between them. It isthe conceptual model that useful in the entity framework infrastructure. There are different typesof element applicable in the ER. Entities RelationshipAttributesAccording to the company scenario, it can be used the different entities in the database tables. EntitiesAttributesEmployeeemp_id (PK)emp_nameemp_ageemp_cityDepartmentDept_id(PK)Dept_name
Dept_locationcarCar_Yearcar_ModelCar_ManufactureSalesmansalesman_id(PK)salesman_NameDependentdependent_Namedependent_sexdependent_DOBdependent_RelationshipMechanicmechanic_id(PK)nameProjectproject_id(PK)project_nameproject_locationWeak entity- In relational database system, A weak entity is basically the entity thatcannot be uniquely identified. It also used as a foreign key in the conjunction with their attributesto create primary key (Felemban and et.al., 2018). According to the case study, dependent isgenerally weak entity that cannot has any unique identified in the database tables. Employee= strong entityStrong entity- This entity is based on the independent and unique. It cannot be dependenton any other entity. For Example- Employee is a strong entity that contain the strong andindependent in the database system. Dependent= weak entityGeneralisation- Generalisation is basically a process that extracts to share thecharacteristics form two or more classes. It also combination of generalized superclass. ForExample- According to ER diagram, it shows the generalisation between the employee,mechanics and salesman. All the entities are connected to create ISA relationship between them. Specialisation- It is a type of process that can be divided the entities into the sub entities.It is also known as top down process to split into the different entity in proper manner.
Specialisation is mainly increased the size of data schema and also splits the entity into themultiple new entities that inherit the features to another entities. TASK 22.1 provide logical database design according to the scenarioLogical database design is necessary for organization to handle the business operationsand function in proper manner. It is the first step for design the data modelling that considered tothe high level abstract design (Groomer and Murthy, 2018). The basic aim of this phase tocontain the information and data in the database system such as entities: department, employee,dependent etc. these are different information contain in the database system. Afterwards, it willcreate relationship between the different data items that used in the database design. Therelationship and constraints are expressed by using the concepts that provided through the levelof data model. It is provided the flexible data structure capabilities and abilities. It contains the data that store in the DBMS. A database is independent regardless of database by using the logical concepts. Primary key-Foreign key- Non- key attribute- Primary key is basicallyknown as unique key thatapplicable in database to createrelationship with another table.It can be stored the uniqueidentifier record such asemployee_id, depart_id etc. Arelational database must becreating by using one primarykey. This key is basically used forlink two tables and alsoapplicable as a reference keyinto another table. ForExample- in Employee_table,emp_id is working as a foreignkey into the department table. It is not part of any type ofkey. It is the simple descriptionand divided into the category.For Example- emp_name,emp_age, emp_id, emp_no etc.All these are the non keyattributes because it cannot beused as key in the databasetables. Logical relationship between the database entities by using primary key, foreign key in tables:
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Food Delivery System Assignmentlg...
|22
|1494
|44
Entity Relationship Diagram for Database INTRODUCTION 3 TASKSlg...
|20
|1532
|227
Database and Analytics (Database and Analytics) for the Auto Sale'slg...
|33
|5085
|217
Entity Relationship Model : Assignmentlg...
|39
|3339
|277
Database and analytical principles PDFlg...
|35
|5004
|498
Introduction to Web and Database Conceptslg...
|23
|2946
|59