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.

To explain the given statement as follows,

Explanation:

1. Purpose of the database:-The purpose of a database is to hoard records. you'll take some quiet data and apply relationships to tow the info into a touch else valuable for business, for tracking fixed charge, etc. A database is worn to collect and arrange data. A database may be a set of data that are prepared in order that it can simply access, direct, and restructured. In one vision, databases are often confidential consistent with sorts of pleased: bibliographic, full-text, numeric, and imagery. Although an electronic report like one shaped in Microsoft Access could also be previous that involves the brain there are many non-automated database editions also, like a personal phone and ask book. A database can just be an inventory that's put aside written or typed on the article, during a computer worksheet or data processing text. this type of database, term a fil, consists of 1 table by rows with a column of knowledge. for instance, a simple database for a small business may need only two features, product name or variety, and price.

2. Describe entities of database and attributes of each entity:-An entity type symbolizes a clear object form. during a real-world model, an entity type may be a vital business entity that holds quite one asset. we'll just call an entity, in its place of an entity type, as in many observe. A relationship type signifies a connection alongside some entities. during a real-world model, a relationship represents a connection that desires to be considered by the database scheme. A relationship type is in a position to be unary, binary, or n-ary counting on whether the figure of entities drawn within the relationship is 1, 2, or further than 2.An attribute is an asset that's worn to inform an entity or a relationship. Prompt that a touch method doesn't permit an attribute during a relationship. An attribute that's a primary key of 1 more relative may be a term far off-key. An entity set may be a set of related entities. An attribute explains assets allied with entities. An attribute will contain a reputation also as a worth for each entity. a website label a group of allowable ideals for an attribute. An entity type is worn to be both a kind of entity with the entity set or gathering of entities of that kind that subsist within the database. In many cases, an entity type has many sub-groupings of its entities that are significant and need to be signifying openly due to their aiming to the database relevance.

3. Describe business rules that could impact the structure of the database:- Business rules subsist for a union whether or not they're yet written along, talk as regards, or yet a bit of the organization’s awareness. Business rules are resultant as an outline of operations. As its name implies, a narrative of operations is an exhaustive tale that explains the operational surroundings of a union. Such a report wants huge accuracy and facet.  Because these mechanisms shape the basis for a database intend, the wary derivation and clarity of business rules are vital to a fine database plan. the info is often measured major only behind business rules are distinct, lacking them it’s now recorded, bar to a business they're the individuality that's definite and sees by the corporate. Business Rules assist employee’s hub off and apply the trial inside the organizations setting. Identify and deed business policy is extremely essential to the database design.

4. 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 almost the desires of the business, not the database while the desires of the business are worn to make the desires of the database. Logical modeling occupies crowd information regarding the business course, business unit also organizational unit. Behind this information is collected, diagrams and hearsay are formed with entity-relationship diagrams, business procedure diagrams, and eventually process flow diagrams.

Physical Modeling:- Physical modeling occupies the important intention of a database consistent with the necessities that were reputable through logical modeling.  Physical modeling contract with the change of the logical or business model keen on an electronic database model. In physical modeling, objects like tables and columns are shaped stand on entities and attribute that be distinct in logical modeling. Restraint is additionally defined, with primary keys, foreign keys extra unique keys with check restraint. Physical modeling is while the whole piece comes mutually to entire the method of major a database pro a business.