08 Normalization I

Computer Science design a RELATIONAL SCHEMA not an ERD for the following A job-shop accounting system is part of an organization that manufactures special-purpose assemblies for customers. A customer has a unique name, an address, and a category (an integer number from 1-10). A customer can order several assemblies. Each assembly is identified by a unique assembly-id, and has a date-ordered, and assembly-details. To manufacture assemblies, the organization contains a number of processes, each of which is identified by a unique process-id and is supervised by one department. Each department has its own department number and department-data. Each process also has process-data. Processes are classified into three types: paint, fit, and cut. The following information is kept about each type of process: Fit: fit-type Paint: paint-type, painting-method • Cut: cutting-type, machine-type During manufacture an assembly can pass through any sequence of processes in any order; it may pass through…

Give Authentic and relevant answer. DATABASE SYSTEMS Construct an Enhanced ERD along with Possible entity clusters of the given below system. This describes the business process to publish an academic paper. The author submits a paper to an editor of a journal. The editor first checks whether the paper fit the theme of the journal. If not, the editor rejects the paper. Otherwise, the editor assigns the paper to a number of reviewers. The reviewers review the paper, and write a review. The review is sent to the editor. The editor then assesses the quality of the paper with the help of reviewers’ comments. If the quality is good, the paper will be accepted, and the author notified. Furthermore, the paper is forwarded to the publisher for publication. If the quality is bad, the editor rejects the paper.

Problem 2: A database for maintaining information about the cities in the United States has the following relation schema Info(city_name, state, governor, mayor) The city_name attribute is the name of a city, state is the abbreviation for state the city is in, governor is the name of the governor of the state the city is in, and mayor is the name of the mayor of the city. For example, the tuple ('New York', 'NY', 'Andrew Cuomo', 'Bill de Blasio') gives information about New York City. Two cities may have the same name (for example there are at least two cities named Portland in the US), but two cities in the same state cannot have the same name. Two states cannot have the same abbreviation. Each city has exactly one mayo and each state has exactly one governor. 1. Which of the following are super keys? Which are candidate keys? (There may be more than one): {city_name} {state} {city_name, state} {city_name, state, mayor} 2. If there are 1000 cities from NY state in a relation of this…

10 The resulting list for each object consists of ordered pairs , which define all domains with a nonempty set of access rights for that object. This statement is TRUE with respect to which of the following methods of access matrix implementation. Global Table Access list for objects Capability list for domains lock-key scheme

The following attributes fom1 a relation that includes information about individua l computers, their vendors, software packages running on the computers, computer users, and user authorizations. Users are authorized to use a specific software package on a specific computer d uring a specific time frame (characterized with attributes UserAuthorization Starts and UserAuthoriza tionEnds and secured with UserAuthorizationPassword}. Software is licensed to be used on specific computers (potentially multip le software packages at the san1e time) until an expira tion time (SoftwarelicensePrice) a t a specific price. Computers are sold by vendors, and each vendor has a support person with an ID, nan1e, and phone extension. Each individual computer has a specific purchase price. The attributes are as follows: Based on this information, a. Identify the functional dependencies between the attributes. b. Identify the reasons why this relation is not in 3NF. c. Present the a ttributes organized so…

16 We would like to design a database to maintain information about COURSES in a Faculty. Each COURSE has a code, name number of credit hours and the department that offers it. A COURSE may have zero, one, or many prerequisite COURSES. A COURSE may be a prerequisite for zero, one, or many COURSES 2"What is the degree of the relationship type'prerequisite of a. A unary (recursive) relationship O b. A binary relationship cA ternary relationship O d. This relationship is NOT exist O

database ERD question

Case Study: Database System for Teaching institution Assume you have been contracted by a teaching institution to develop a database systemto keep track of student registration and accommodation records.The institution courses are offered by instructors during physical classes. Depending onthe student’s IQ, there are no limitations to how many courses a student can enroll in.administrators are responsible for student accommodation. This institution owns anumber of rooms for accommodation and each student is given a shared room key afterenrollment. Each room has furniture attached to it. question- draw a single ER diagram to represent the data requirements for the project based on Chen Notation. use any Online editor to create the that supports Chen Notations to create the model?

Entity relationship diagram.

1. What technique is used to model the situation that Student may have multiple addresses? A) Associative Entity (gerund)B) Weak entitiesC) Super/sub typesD) Recursive relationships 2.There is m:m relationship between students and classes. Which technique is used forrepresenting the student grade? A) Associative Entity (gerund)B) Weak entitiesC) Super/sub typesD) Recursive relationships 3. An associative Entity (gerund) may be used whenever there are data that depends on twoentities even when their relationship is 1:m. True or FalseA) TrueB) False 4. (check all that apply) When do you use recursive relationships?A) the relationship between employees and their supervisorsB) the relationship between employees and their dependentsC) the relationship between employees and their departmentsD) the relationship between employees and their team membersE) the relationship between employees and their job assignments 5. How is a gerund converted into a relational model?A) ignore the gerund in the…

Random Hospital Example ERD Problem Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information.   Remember the ERD will eventually turn into the design for a database from a top down view.  Make sure you resolve any many to many conflicts.  Label an identifier or primary key and all pertinent attributes given.   If an attribute is not readily apparent from the user information, then make one up that makes sense for the particular entity.  Therefore, all entities should end up with at least an identifier and another attribute that makes sense. You may use any of the approaches shown by the book, though the ER-Model and Crow’s foot are the most common.  Make sure you show entities, relationships, cardinality, and optionality.  Random Hospital Example A hospital has 10 wards, each containing up to 20 patients.  Patients have only one doctor allowed to prescribe drugs for them.  Doctors do their rounds once a day and prescribe drugs by…

DATABASE SYSTEM A relation R is given which is R(A,B,C,D,E). It has the following functional dependencies: BC  -> ADE , D -> B. Answer the following based on this information. Which normal forms does this relation satisfy? Which type of dependencies does this relation violate? Normalize the relationship so that it decomposes to 3NF.

Introduction to data base

Relational model: In the personal model, data are prearranged in tables, which contain of table. A data in a table is called fields. Fields in a db table are also referred as qualities of a db object. A group of related fields are called as a record, which I also called as db object or entity. A group of records are called a table. Keys in a relational db table refer to a key field. To identify each record in a table, there must be at least one data field that should be unique. That is, a corresponding data field of every record should be unique. Therefore, key field is used to identify the unique record from a collection of records.

A record company wishes to use a computer database to help with its operations regardingits performers, recordings and song catalogue. A requirements analysis has elicited the followinginformation:Songs have a unique song number, a non-unique title and a composition date. A song can be writtenby a number of composers; the composer’s full name is required. Songs are recorded by recordingartists (bands or solo performers). A song is recorded as a track of a CD. A CD has many songs on it,called tracks. CDs have a unique record catalogue number, a title and must have a producer (the fullname of the producer is required). Each track must have the recording date and the track number ofthe CD. A song can appear on many (or no) CDs, and be recorded by many differentrecording artists. The same recording artist might re-record the same song on different CDs. A CDmust have only 1 recording artist appearing on it. CDs can be released a number of times,and each time the release date and associated…

Define relation

Consider the following information about a patient database

A bank provides services to customers. The banks is identified by its code and has a name and an address. The bank has several branches. A branch is identified by its code that is unique for a given bank. The branch name and address are also stored in the database. Customers deal with the bank through the bank branches. So, a customer belongs to a specific bank branch. Customers either open bank accounts (CURRENT, SAVINGS, etc.) or receive bank loans (DIRECT, INDIRECT, etc.) from the bank. The bank stores customer info namely: EID, name, phone, and address. The bank also keeps track of customers’ loans and accounts. Information stored about loans include loan no, amount, and type. Account information stored is account no, balance, and type. The address information stored for any entity includes street number, street name, PO Box, city, and emirate. Draw an ER diagram representing the needed database.

Ch. 4-problem 3: Given the business rule “an employee may have many degrees,” discuss its effect on attributes, entities, and relationships. (Hint: Remember what a multivalued attribute is and how it might be implemented.) Suppose that an employee has the following degrees: BA, BS, and MBA. These degrees could be stored in a single string as a multivalued attribute named EMP_DEGREE in an EMPLOYEE table such as the one shown next: EMP_NUM EMP_LNAME EMP_DEGREE 123 Carter AA, BBA 124 O’Shanski BBA, MBA, Ph.D. 125 Jones AS 126 Ortez BS, MS   Ch. 4-problem 4: What is a composite entity, and when is it used?   Ch. 4-problem 5: Suppose you are working within the framework of the conceptual model in Figure Q4.5.   Figure Q4.5 The Conceptual Model for Question 5   Given the conceptual model in Figure Q4.5: Write the business rules that are reflected in it.   Identify all of the cardinalities.   Ch. 4-problem 6: What is a recursive relationship?…

Problem: design a er diagram for a database to keep track of building inspections required by a department of Damaged Buildings (DB). DB  building inspections are requested by builders every month. Each building inspection is either passed or not. Inspections have a type code (3 characters, e.g. PLU, FRM, ELE, etc.) and possibly sequencing requirements. Some inspections cannot be performed before other inspections, e.g. final plumbing inspection cannot be performed until the framing inspection is passed. Each inspection has a numeric score, with 75 or more out of 100 being sufficient for a pass status. Each inspection data contains the date of inspection, inspector identification, inspection score, and textual information about the inspection. The textual information can be updated later, but the score can never be changed. FODB maintains a pool of inspectors. Each inspector has a unique 5 digit employee ID, name, and date they were hired. They can conduct any type of inspection but…

Create a conceptual schema for the following database domain. To make it completely clear, only one (the final) conceptual schema is expected. A book is described by ISBN and a title. ISBN uniquely identifies each book. A book consists of many chapters. A chapter is described by a chapter number, title and topic. Each chapter has a unique number within a book. A chapter belongs to one book only. A book is written by one or more authors. An author can write one or more books. An author is described by the first name, last name, date of birth, and country the author comes from. A triple of values: (first name, last name and date of birth) uniquely identifies each author. We have three types of books: textbooks, fiction books and biographies. A textbook is additionally described by the titles of course it has been applied to. A textbook can be applied to none or more courses. i need answer with diagram

4. Write the relation matrix for the relation R on the set (a,b.c.d.e.f) which is defined as follows: R={a,a), (a,b), (a,c), (b,a). (b,c). (c,a), (c,b), (d,d), (f.f).

Computer Science Relational Model (Logical and Physical Schema Development) The conceptual model developed in phase 2 will be transformed into a logical and physical schema using the relational data model. The outcome of this transformation will be a relational schema. The schema should have the following components: Set of required relations All the integrity constraints Submission and Evaluation: A report consisting of the problem statement, ER diagram, relational schema And implement the database using SQL should include: All the tables properly defined /created All constraints properly defined For each table, few instances of data should be entered.

PART C QUESTION 1 The NAN Book Rental Shop is seeking to implement a database system for its shop. The shop has customers known as members, and a collection of books available for rental. The purpose of the system is to track membership, book inventory, and book rental activities. The following are the current system descriptions associated with NAN Book Rental Shop. For each member, the data items that need to be recorded are: a unique membership identification number, the members' name, address, phone number and the date that the members joined the shop. • When a member rents a book, the shop will record these items: the book rental date, the book return due date, the date the book was returned, and the rental fee. Each member can rent a maximum of five books at any one time and the members must return the books in two weeks time. For each book, the book's identification number, title, type and rental price must be collected and stored in the system. Sometimes books are written by…

Objective: To create a JSON for Scheme details with objects   Scenario: Government wants to create a database for schemes launched in respective country.   Application sends the details of schemes in the form of JSON Help to create a JSON with the information provided.     Name Datatype of value Scheme String MinistryDetails Object LaunchedYear Number Country String BudgetInCrores Number     MinistryDetails- Object :    Name Datatype of value Ministry String MinisterName String HeadOfMinister String

Suppose that you are given the following information for the articles publications: • Each article is published in a Journal only. Article may have their own identification number, name, and any other relevant information. Articles cannot be duplicated and will be only accepted in a Journal. Journal will have their identification number, name, any other relevant information. • Authors may publish one or more articles at a time, but each article must be distinctive and published in the appropriate journal. If necessary, the author may be required to present their work at a specific conference. The details of the conference must also be recorded. A reviewer will examine an article before it is published. Each reviewer is only allowed to review two articles from the same journal. Sketch an Enhanced Entity Relationship Diagram (Chen's Model) based on the scenario above. Include all the relevant entities and you are also encouraged to add any other relevant entities to specify the…

Suppose you are asked to design a club database system based on the following information. Each student has a unique student id, a name, and an email; each club has a unique club id, a name, a contact telephone number, and has exactly one student as its president. Each student can serve as a president in at most one of the clubs, although he/she can be the members of several clubs. Clubs organize activities and students can participate in any of them. Each activity is described by a unique activity id, a place, a date, a time and those clubs that organize it. If an activity is organized by more than one club, different clubs might contribute different activity fees.QuestionDraw an E-R diagram for the system according to the above description.

Computer Science Design an OO schema for a database application that you are interested in.Construct an EER schema for the application, and then create the corresponding classes in ODL. Specify a number of methods for each class, andthen specify queries in OQL for your database application.