Relational Schema Assignment Help | Project | Homework Problem Solution

Data base uses relational schema for the relation of data and the DatabaseHomeworkHelp is related to provide the relational schema assignment help. Availability of our service is everywhere and with just an email you can get our relational schema homework help. Profound nature of our help with relational schema assignment will bring you decent grades.

We are respectably famous too for our help with relational schema project. Different kind of literature and tutorials are accessible on the web for the relational schema problem solution but we do the customized solution for your problems. You have to pay less for the quality and precision in our relational schema project help.

Continuously showing the aptitude of assisting students by relational schema online expert tutor we title ourselves the best. Success is not far from you if you are getting our relational schema assignment help. We are determined to prove our tailored relational schema homework help unique and perfect too.

It is amazing how our professionals can give you help with relational schema assignment irrespective of complication of work. Relational schema is basic to data base as the help with relational schema project is basic to get good marks. We are broken every limit of complexity for showing you the relational schema problem solution.

Relational schema is table attributes design that showcases the relationship using logical data model. It is also called as relational paradigm. An E-R diagram is usually converted in relational schema mapping relationship.

Note:-The below Relational Schema solution is just a sample example that we have provided for you. It does not contain any question and answers from our solved homework solutions that we have provided to our clients in the past. These solutions are sole property of dbmshomworkhelp. We are committed to provide excellent solution with quality check while delivering to our clients.

Question:-The aim of this task is to define the relational schema and to normalize it. The normalization includes all the three normal forms. The relations are divided into more sub relations where the functional and partial dependencies are removed.

Solution:

Employee(Employee_ID, Employee_name, payroll_address, date_employeed, skills, year_Employeed)

a)      Relational Schema:

rs

The employee table is divided into two tables.

Employee which contains the following columns

Employee_ID, mployee_name, payroll_address, data_employeed

 Emp_skills

EmployeeID, Skills

Both are primary keys.

b)The employee table has following dependencies which are shown in diagram.

rs1

The EmpSkills table has following dependencies which are also shown here.

rs2

c) As both the table are fully dependent upon the primary key of both tables and not on any other attributes so the relations are in already in 3NF

Figure 3.9-B

a)

rs3

After decomposing because the no_of_passenger can be calculated field from the booking entity

rs4

b)

Functional dependency diagram

rs5

rs6

 

c) The above relations are already in3NF and there is no attributes other than the primary key which identify any non key attributes.

Figure below

rs7

The movie_id is acting as primary key in the movie table but as a foreign key in the DVD table which is stock table.

The copy_number and movie number is both composite primary key here.

b) Functional dependency diagram.

Movie Table

rs8

DVD Table:

rs9

c) The above all tables are in 3NF

Figure 5.5

rs10

Solution:

The given table is in the form as

Shipment(shippmentID, Origin, destination,ShipNumber,ShipmentDate,ExpectedArrival,Captain, itemNumber,Type,Description,Weight, Quantity,TotalWeight,ShipmentTotal)

The table is in first normal form there are many repeated groups so we have to remove them

b) Functional dependency diagram for the given table

rs11

The table has many data redundancy so it need to be split.

Those columns that are fully dependent upon the shipmentID will be converted into one table

Shipment(ShipmentID, Destinatiion, ShipNumber, Origin, ExpectedDate,ShipmentDate,captain)

Item(ItemNumber,Type, description, weight, Quantity)

ShipItem(ShipmenID, ItemNumber, Quantity)

The total quantity is derived from the quantity column so it is not included in the schema.

c)

rs12

Three NF

rs13

The above schema is in 3NF as all the attributes in the each entity is only dependent upon the primary key of that entity. There is no transitive relationship between any attributes.