LOGICAL DATA MODELLING AND SQL Coursework Example | Topics and Well Written Essays - 1750 words - 1

LOGICAL DATA MODELLING AND SQL - Coursework Example In this case study of the SOUNMISSION Company, we have been given the conceptual diagram and we are required to form the logical Entity Relationship Diagram (ERD) based on the conceptual diagram. The logical data model is developed without considering the database tools to be used for creation and implementation of the database. The logical ER data model facilitates to identify and specify additional data entities include but not limited to the Transactional and Operational data entities. Moreover, the logical ER data model contains more information related to the relationships, primary and foreign keys, as compared to the conceptual data model. In the ER logical models the attributes of the entities are defined, refined and categorized in diverse attribute types include: the derived attributes, composite attributes, multi-valued attributes, null and simple attributes. Furthermore, relationships are established in the logical ER data model. There are three (3) major types of the relationships include: one-one (1 to 1), one-many (1 to many) and many to many relationship. The relationships are based on the primary key and foreign key. The base table contains the primary key that makes a relationship with the other data type contains the foreign key. Usually, this type of relationship is said to be ‘one- to-many’ relationship. However, the same relationship can be changed by implementing constraint of uniqueness to the attribute / foreign key to restrict the duplicate values. This implies that the established relationship is one to one because both the data entities contain the non-duplicate value (Tao, n.d). The document presents the conversion of the conceptual data model into the logical data model for the company named SOUNDMISSION. Moreover, the document can be considered as the base document for the development of the database for the company. In the beginning, it is required to identify the

Information System Project Management Research Paper

Information System Project Management - Research Paper Example Week 10 Week 11 Testing Testing Testing Week 12 Week 13 Coding Week 14 Week 15 Testing Coding Week 16 Testing Testing Week 17 Coding Coding Coding Week 18 Testing Testing Testing Week 19 Week 20 Write a memo to Tom Jones explaining if john can or cannot meet Tom's goal of five Months. Inter office Memo From: Project Manager To: Accounts Manager I am attaching the project schedule with this IOM. Please go through it. Here I want to inform you that according to this project schedule we can complete this project in given time of five months. To complete this project within the time limit, we need your support and co-operation time to time. John Price Project Manager How Should John ensure that the project is completed on time as determine by the network Is there any way the time for the project can be shortened Using this project schedule john can easily ensure that project can be completed on time. For completing the project on time from networks point of view, John need to focus on the work done by networking department. Because in the project schedule only the network manager has a longer lead time to complete this project. Network manager is taking 13 weeks for completing its work. Any delay in networking work may cause delay of the project. To avoid delay in networking John has to ensure that each & every activity scheduled in project should complete on time. If there are some problem in completing an activity, then early decision are to be made to rectify the problem. John should make a grid on a paper and keep this paper on his table every time. After completing of activity John can tick on the grid and can have a overview on the complete project. Yes, the project time...Network manager is taking 13 weeks for completing its work. Any delay in networking work may cause delay of the project. To avoid delay in networking John has to ensure that each & every activity scheduled in project should complete on time. If there are some problem in completing an activity, then early decision are to be made to rectify the problem. John should make a grid on a paper and keep this paper on his table every time. After completing of activity John can tick on the grid and can have a overview on the complete project. Yes, the project time can shortened if the design the network changes can be completed in one week instead of two weeks, if the cabling can be completed in one week instead of two weeks, if the quotation open can be completed in 4 weeks instead of five weeks. So over all three weeks can be free if we shorten only three activities. So if we keep concentrate on each an every activity then only the project can be complete early. Raw Material: There should be some procedure of quality control to check the incoming material. If the incoming material is of good quality then obliviously the final product will be made of good quality. There may procedure to test the incoming material in quality control department. Machines: The maintenance of machine should be on time, so that they will not malfunction during the project work.