Suppose a local college has tasked you to develop a database that will keep trac

Question

Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and courses, the client wants the database to keep track of the instructors teaching each of the courses. Use the internet to research the types of information that a college would want to track in a database. Focus your attention on information that could represent entities within a database as well as attributes of such entities. 1.Describe the purpose of the database. 2.Based on your research and / or common knowledge of a college and the information tracked by a college, describe the entities of the database and the attributes of each entity. 3.Based on your research and / or common knowledge of a college and the information tracked by a college, describe the business rules that could impact the structure of the database. 4.Determine the information that the conceptual model of the database would include and determine the information that the physical model of the database would include.

Explanation / Answer

Purpose of the database:-The purpose of a database is to hoard records. You can take some kind of data and apply relationships to tow the data into a bit else valuable for business, for tracking fixed cost, etc. A database is worn to gather and arrange data. A database is a set of information that is prepared so that it can simply be access, direct and restructured. In one vision, databases can be confidential according to types of pleased: bibliographic, full-text, numeric and imagery. Although an electronic report such as one shaped in Microsoft Access may be the former that comes to brain there are lots of non-automated database edition as well, such as a private phone and talk to book. A database can just be a list that is set aside written or typed on article, in a computer worksheet or word processing text. This sort of database, term a flat file, consists of one table by rows with column of data. For example, an easy database for a tiny business might have only two feature, product name or variety and cost.

Describe entities of database and attributes of each entity: - An entity type symbolizes an obvious object form. In real-world model, an entity type is a vital business entity that holds more than one asset. We will just call an entity, in its place of an entity type, as in many observe. A relationship type signifies a connection along with some entities. In real-world model, a relationship represents a connection that desires to be considering by the database scheme. A relationship type is able to be unary, binary, or n-ary depending on whether the figure of entities drawn in in the relationship is 1, 2 or further than 2.An attribute is an assets that is worn to tell an entity or a relationship. Prompt that a little method does not permit an attribute in a relationship. An attribute which is a primary key of one more relative is term a foreign key. An entity set is a set of related entities. An attribute explain an assets allied with entities. Attribute will contain a name as well as a value for every entity. A domain label a set of allowable ideals for an attribute. An entity type is worn to be both a type of entity with the entity set or gathering of entities of that sort that subsist in the database. In lots of cases an entity type has many sub groupings of its entities that are significant and require to be signifying openly because of their meaning to the database relevance.

Describe business rules that could impact structure of the database: - Business rules subsist for a union whether or not they are yet written along, talk as regards or yet piece of the organization’s awareness. Business rules are resultant as of a depiction of operations. As its name imply, a narrative of operations is an exhaustive tale that explain the operational surroundings of a union. Such a report wants huge accuracy and facet. If the report of operations is false or unfinished, the business rules resulting from it will not return the valid world data situation exactly, thus chief to weakly defined data models, which escort to meager database designs. In turn, meager database designs escort to poor applications, thus set the phase for poor choice making – which may finally guide to the end of the business. Correctly written business rules are worn to name entities, attributes, relationships and restraints. Because these mechanism shape the root for a database intend, the wary derivation and clarity of business rules is vital to fine database plan. The data can be measured major only behind business rules are distinct, lacking them it’s now records, bar to a business they are the individuality that are definite and see by the company. Business Rules assist employee’s hub on and apply the trial inside the organizations setting. Identify and deed business policy is very essential to the database design.

Determine information conceptual model of the database & that physical model of the database would include:-

Logical Modeling: - Logical modeling pact with crowd business necessities also converts those necessities into a model. The logical model turns just about the desires of the business not the database while the desires of the business are worn to create the desires of the database. Logical modeling occupies crowd information regarding business course, business unit also organizational unit. Behind this information is collect, diagrams and hearsay are formed with entity relationship diagrams, business procedure diagrams and finally process flow diagrams. The diagrams formed must illustrate the processes with facts that live, as well as the relationships among business processes with data. Logical modeling must correctly give an illustration depiction of the tricks and data related to a meticulous business.

Physical Modeling: - Physical modeling occupies the real intend of a database according to the necessities that were reputable through logical modeling. Logical modeling chiefly grip assembly the necessities of the business, with the final component of logical modeling intended for near the goals and necessities of the database. Physical modeling contract with the change of the logical or business model keen on a relational database model. In physical modeling, objects such as tables and columns are shaped stand on entities and attributes that be distinct in logical modeling. Restraint is also defined, with primary keys, foreign keys extra unique keys with check restraint. Physical modeling is while the entire piece comes mutually to entire the process of major a database pro a business. Physical modeling is database software exact sense that the matter distinct during physical modeling can contrast depending on the relational database software mortal used. For example, mainly relational database systems contain variations with the means data types are signify and the way data is hoard, while basic data types are theoretically the similar amid unlike implementations.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.