Categories
Uncategorized

Information Technology 3 Assignment Questions and Answers Help

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!

Information Technology 3

 

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

 

For REF… Use: #getanswers2002100 J

 

The post Information Technology 3 Assignment Questions and Answers Help appeared first on Assignment Help Australia Site.

CLICK HERE TO GET THIS ANSWER