Information Technology 3 Assignment Help

If you are looking for Information Technology 3 Assignment Questions and Answers Help? Get quality and unique online writing services at an affordable price. Enhance your grades by hiring MBA assignment writers from Assignment Help AUS. Our 24/7 Live Service always guide your Information Technology 3 Assignment Help. Hurry up place your order now!

 

Assignment 1

QUESTION ONE

 

Note this section is research based and requires you to consult other resources beyond the module guide such as internet sources.

 

ENTITY RELATIONSHIP DIAGRAM

 

Pet Mart has requested you to design a database to store information on sales on animals and merchandises. The sales form is shown in the figure below:

 

 

• With the use of a relevant table identify all entities and attributes for each entity from the sales form in the figure above and provide your answer in the following format.

 

ENTITY	ATTRIBUTE
XXXX	XXXXXX

 

• Using the answers in the question above, construct a complete conceptual Entity Relationship Model (ERM) to model the data in the Sales Form. Multiplicities and primary keys must be depicted in your model.
• An IT Training Company has 30 instructors and can handle up to 100 trainees per training session.

 

The Company currently offers five advanced technology courses, each of which is taught by a teaching team of two or more instructors. Each instructor is assigned to a maximum of two teaching teams or may be assigned to do research. Each trainee undertakes one advanced technology course per training session.

 

Using the information above construct a entity relationship diagramme that shows the main entity types, relationships and data requirements for the company.

 

QUESTION TWO

 

• A DBMS performs several important functions that guarantee the integrity and consistency of the data in the database.

With regards to the above information elaborate on how a database management system secures the integrity and consistency of data.

• Examine why the object orientated model is best suited for today’s complex data environments.

 

QUESTION THREE

 

• Assess the concepts connectivity and cardinality with reference to relationship classification in database design.
• Elaborate on the design challenges and conflicting goals that database designers

 

Assignment 2

 

QUESTION ONE

 

Note this section is research based and requires you to consult other resources beyond the module guide such as internet sources.

 

Read the following information and answer the questions that follow:

 

Full Names	Physical Address	Movies Rented	Salutation	Category
Janet Jones	First Street Plot no 4	Pirates of the Caribbean Clash of the Titans	Ms.	Action Action
Robert Phil	3rd Street 34	Forgetting Sarah Marshal, Daddy’s Little Girls	Mr.	Romance Romance
Robert Phil	5th Avenue	Clash of the Titans	Mr.	Action

 

• Convert the above database table into the first normal form (1Nf).
• Using your answer to the question above, convert the database to the second normal form, (2NF).
• Convert your answer in question 1.2 to the third normal form, (3NF).

 

QUESTION TWO

 

• Assess the role of each of the different types of attributes in database design.
• Elaborate on the challenges associated with database design

 

QUESTION THREE

 

• Determine the role of normalisation in ensuring that database design is efficient.
• Examine the advantages off the network model as compared to the hierarchical database model.
• Elaborate on how data and information influences database creation.

 

For REF… Use: #getanswers2002100 J