Logical Design Essay Sample

1. List the advantages of a relational theoretical account specific to ACME Global Consulting.

The relational database theoretical account specified for the ACME Global Consulting organizes given informations in table series. Each of the tabular array has Fieldss specified with specifications sing the information type stored ( Easytoteach. 2011 ) . The advantages of the relational theoretical account includes

• Conceptual simpleness. the theoretical account should be conceptually unworldly compared to the web and hierarchal theoretical accounts.

• Structural independency. with the specifications of the relational theoretical account for the ACME Global Consulting. any comparative alterations made on the construction should non impact the handiness of informations.

• Design execution. the theoretical account specified is capable of file awaying the structural independency and informations independency.

• The theoretical account has query capableness ; the handiness of the powerful. flexible. and simpler in usage capableness is a important ground behind the huge database theoretical account popularity.

• Flexibility. the theoretical account with the given differing tabular arraies that accommodates information has to associate and hold easy extraction for easy use by the respective operators inclusive of undertakings and the articulation. This is to fall in and give the relevant information in the needed signifier that is desired ( Singh. 2009 ) .

• Precision. this is important in relation to the application of relational algebra and concretion for the uses of the nexus amid the given tabular arraies. This ensures that ambiguity is absent that may originate following the constitution of linkages in a specified complex web database type ( Singh. 2009 ) . 2. Sum up in your ain words the intent of an E-R theoretical account specific to ACME Global Consulting.

The application of the E-R theoretical account by the ACME Global Consulting enables the presentation of a powerful database design comparatively important to clients. The theoretical account provides advisers for the execution of flexible and unlittered design and aids in the confirmation of information demands. This is before the proceeding made towards the specified existent execution ( Singh. 2009 ) . This besides has an increase with the apprehension of jobs bing. The E-R theoretical account incorporates informations mold technique at a higher degree puting down of the conceptual design important for the database. It constitutes of the specified figure of critical constituents inclusive of properties. entities. and relationships for the ACME Global Consulting ( Easytoteach. 2011 ) .

The ACME Global Consulting squad has the clear apprehension of information demands through the E-R that enables client interaction and treatments through informations ocular representations for the demands of informations to be verified for farther stairss. The E-R besides enables the increase of communicating with aid in the integrating of the relational database theoretical account. The scheme diagram forms the footing for system database with ACME Global Consulting client’s solution with file designs for the specified file systems through an attack of informations base transition ( Easytoteach. 2011 ) .

3. List and depict indispensable constituents of the theoretical account such as entities. properties. keys. relationships. functions. and dependences specific to ACME
Global Consulting

The indispensable constituents includes

Entity is the name of the existent universe construct holding physical being. A comparative illustration of the specified entity is the client for the company’s client direction solution ( Easytoteach. 2011 ) .

Properties. the belongingss associating to the specified entity are the properties including reference. names given to the entity clients specific to ACME Global Consulting ( Easytoteach. 2011 ) .

Relationship. the term refers to the rate at which entities relates to each other. The differing relationship types in the E-R includes

• The one to one connexion. which involves merely one case of the entity to the other related case of another different entity

• One to legion relationships affecting one case of the specified entity associating to the other 2nd entity cases

• Majority to the one relationship. the bulk of the garrisons entity relates to the lone significant case of the specified 2nd relationship.

• Majority to bulk relationships. which involves the bulk of cases of the specified first relationship associating to the remainder of the cases of the relating entity

Keys. the given figure of restraints employed on the care of informations unity enables procedural saving. The significant keys that are supported by the E-R theoretical account includes

• The primary key. this reflects the important property holding the alone values as underlined in the E-R theoretical account.

• The foreign key. this is the critical key of the specified tabular array. It relates to the other tabular array for comparative functional dependence.

4. Describe the demand for the enhanced E-R theoretical account and how we can make sophisticated theoretical accounts to assist us in complex environments

The enhanced E-R theoretical account is important since it contains the important informations types. categories. specialisation constructs and generalisation provided in the theoretical account. The enhanced E-R theoretical account applies to the ACME Global Consulting for clear contemplation of the information demands of the specified system. All the strategized inside informations in the E-R aid in the layout of all star basic inside informations of informations necessities inclusive of the informations nature. The enhanced E-R theoretical account is important since the specialisation and generalisation involved aids in the description of the properties shared amid the differing entities ( Khan et al. 2011 ) .

The creative activity of the sophisticated theoretical accounts involves the application of interviews. workshops. and meetings techniques as a agency of understanding the demand evocation. The demands should be references with clients concerns with member analyzing the specified system for the necessary procedures involved as facing by the current system. For the successful creative activity of the sophisticated theoretical accounts. the demands elicited must be accomplished ( Khan et al. 2011 ) .

5. Outline and depict the advantage of utilizing the relational theoretical account.

The major advantages of using the relational theoretical account include informations use retrieval and security. The mandate and security control execution are easier through the motion of sensitive properties in the specified tabular array. This is into the separate relation with mandate controls. When the mandate necessitates licenses. the specified property is joined with the remainder to enable information retrieval in full ( Khan et al. 2011 ) .

The use of the informations linguistic communication involves the possibility of doing a response to the ad-hoc specifications through linguistic communication agencies establishing on the relational algebra with concretion. For the informations organized with the other related construction. the query linguistic communication. hence. it is highly capableness has restrictions ( Khan et al. 2011 ) .

6. Make an E-R diagram utilizing graphical depiction package that could theoretically be applicable in a eating house application.

[ movie ]

The set representation of the diagram picturing the entity types

[ movie ]

A diagram stand foring the relationship type with opposite received

Mentions

Easytoteach. ( 2011 ) . What is Relational Model. Advantages and Disadvantages of Relational Model. Retrieved from hypertext transfer protocol: //easy2teach. net/database/what-is-relational-model-advantages-and-disadvantages-of-relational-model

Khaled M. Khan. Mahesha Kapurubandara & A ; Urvashi Chadha. ( 2011 ) . Integrating Business Requirements and Constraints in Database Conceptual Models. Proceeding of the first Asian-Pacific conference on Conceptual mold. Volume 31. pp: 59-64. Australian Computer Society. Inc. ) Singh. S. K. ( 2009 ) . Database Systems: Concepts. Design and Applications. E Rutherford: Prentice Hall Imprint.