BCSL-034 ASSIGNMENT SOLUTION (2019-20)

If you have any queries please leave a message here
Your Message
×


Q1. An ABC Event Management Company requires a computerized system to automize its operations that support the following activities :

Perform the following tasks :

(i) Using any of the drawing tools like smartdraw, dia, visio, conceptdraw etc. or else by your own hand, draw the complete ER diagram for the above event management system by identifying the entities, relationships, cardinality and key constraints. Follow proper conventions.

Answer : -




(ii) Create database to support/accommodate all the functionalities referred above. Perform Normalization till required NF and prepare Normalized tables.

Answer : - I use Microsoft Office Access 2007 to create all the tables given below -

Table Name : admin

Field NameData TypeConstraintDescription
idNumberPrimary KeyUniquely identify each admin member in this table
nameTextName of the admin member
addressTextPresent address of the admin member
phoneNumberContact number of the admin member
designationTextDesignation of the admin member


Table Name : login

Field NameData TypeConstraintDescription
usernameTextPrimary KeyUsername for admin login
passwordTextPassword for admin login


Table Name : team

Field NameData TypeConstraintDescription
team_idNumberPrimary KeyUniquely identify each team in this table
team_nameTextName of the team
event_idNumberForeign KeyUniquely identify each event in the "event" table


Table Name : member

Field NameData TypeConstraintDescription
member_idNumberPrimary KeyUniquely identify each team member in this table
member_nameTextName of the team member
member_addressTextAddress of the team member
member_phoneNumberContact number of the team member


Table Name : include

Field NameData TypeConstraintDescription
team_idNumberForeign KeyUniquely identify each team in the "team" table
member_idNumberForeign KeyUniquely identify each team member in the "member" table


Table Name : event

Field NameData TypeConstraintDescription
event_idNumberPrimary KeyUniquely identify each event in this table
titletextName/Title of the event
event_dateDate/TimeDate of the event
event_timeDate/TimeStart time of the event
durationNumberDuration of the event in minute
entry_feeNumberTicket price of the event


Table Name : items

Field NameData TypeConstraintDescription
item_codeTextPrimary KeyUniquely identify each item in this table
item_nameTextName of the item
item_priceNumberPrice require for this item


Table Name : require

Field NameData TypeConstraintDescription
event_idNumberForeign KeyUniquely identify each event in the "event" table
item_codeTextForeign KeyUniquely identify each item in the "item" table


Table Name : participant

Field NameData TypeConstraintDescription
p_idNumberPrimary KeyUniquely identify each participant in this table
p_nameTextName of the participant
p_addressTextAddress of the participant
p_phoneNumberContact number of the participant


Table Name : booked

Field NameData TypeConstraintDescription
event_idNumberForeign KeyUniquely identify each event in the "event" table
p_idNumberForeign KeyUniquely identify each participant in the "participant" table
ticket_noNumberTicket number for the participant





ABOUT US

QuestionSolves.com is an educational website that helps worldwide students in solving computer education related queries.

Also, different software like Visual Studio, SQL Server, Oracle etc. are available to download in different versions.

Moreover, QuestionSolves.com provides solutions to your questions and assignments also.


MORE TOPIC


Windows Command

UNIX Command

IGNOU Assignment Solution

IGNOU Question Paper Solution

Solutions of Different Questions


WHAT WE DO


Website Devlopment

Training

Home Learning

Provide BCA, MCA Projects

Provide Assignment & Question Paper Solution


CONTACT US


Follow Us