A publisher needs to create a database based on the following requirements: The publisher publishes different...

A publisher needs to create a database based on the following requirements:

The publisher publishes different books. Each book has an ISBN, name, author(s) name, edition number, category, and price. Each book has a unique ISBN.

The publisher deal with many authors, each has a name, unique number.

For every book, each author will have different percentage of revenue.

They also hire editors, who edit books before publishing. Each has name, unique number, SSN, salary, book category and list of books they edited.

Draw a complete ER diagram. Write the (min,max), total/partial and the cardinality ratio.

Expert Solution

Min Cardinality:The minimum number of occurrence of an entity that participates in a relationship.

Max Cardinality: The maximum number of occurrence of and entity that participates in a relationship.

Cardinality Ratio: Cardinality Ratio is the ratio of participation between two entities. Types : one to one,one to many, many to one, many to many.

Total participation: In Total participation, every entity of the entity set must participate in the relationship. e.g every student in the student entity must enroll in a course, student will have total participation.

Partial participation :In partial participation , not every entity in the entity set is required to participate in the relationship.

venereology answered 4 months ago

Using your downloaded DBMS (MS SQL Server), create a new database. Create the database tables based...

Using your downloaded DBMS (MS SQL Server), create a new database. Create the database tables based on your entities defining The attributes within each table The primary and foreign keys within each table *****Show your database tables, tables attributes, primary and foreign keys***** Do not forget to check the lesson slides and videos that show you how to convert an ER/EER into a database schema, and how to create a database and tables using MS SQL Server.

1. A cosmetic product retailer needs to create a database to keep track of the information...

1. A cosmetic product retailer needs to create a database to keep track of the information for its business operations. The company has a web site that posts all its products. The product information includes product ID, product name, description, and unit price. The company also needs to keep track of customers’ information, including customer names, their shipping addresses, and the email address. The company creates an account for each customer for identification and tracking purpose. A customer can purchase...

Requirements. A television channel has decided to create a simple database to register payment information about...

Requirements. A television channel has decided to create a simple database to register payment information about its most successful show ‘TheVoiceLondon’. In this show, there are contenders that compete to represent the UK in Eurovision. These contenders are coached by famous artists (namely the coaches). Contenders can be formed by a group of participants or a single participant. Both coaches and participants are paid based on the number of shows they attend. For each coach and participant, the database stores...

Case Azzahra is a book publisher, publishes and distributes educational and non-educational books and sell them...

Case Azzahra is a book publisher, publishes and distributes educational and non-educational books and sell them to libraries and bookstores within Saudi Arabia and in the Arabian Gulf Region (AGR). Azzahra employs a professional editorial team. All printing and binding activities are outsourced. The annual revenue total 250 millions Saudi Riyals which are disbursed as follows: In millions Cash Credit Total Total Customers Within Saudi 40 120 160 4680 From other AGR 10 80 90 2120 Total 50 200 250...

Database Systems Lab Exercises Create a table Faculty based on the following chart: Column Data type...

Database Systems Lab Exercises Create a table Faculty based on the following chart: Column Data type Constraints Faculty_Id Number (6) Primary Key => faculty_pk Last_Name Varchar2(15) Not NULL First_Name Varchar2(15) Not NULL Dept Char(3) Save the SQL statement as ex1.sql. Confirm and validate the creation of the new table. Create a table Dept based on the following chart: Column Data type Constraints Dept_Code Char (3) Primary Key => dept_pk Dept_Name Varchar2(20) Not NULL Save the SQL statement as ex2.sql. Confirm...

Information on the following Database: create database Sales_Co use Sales_Co create table Vendor (v_code integer, v_name...

Information on the following Database: create database Sales_Co use Sales_Co create table Vendor (v_code integer, v_name varchar(35) not null, v_contact varchar(15) not null, v_areacode char(3) not null, v_phone char(8) not null, v_state char(2) not null, v_order char(1) not null, primary key (v_code)); create table product (p_code varchar(10) constraint product_p_code_pk primary key, p_descript varchar(35) not null, p_indate datetime not null, p_qoh integer not null, p_min integer not null, p_price numeric (8,2) not null, p_discount numeric (4,2) not null, v_code integer, constraint...

Your organization's database needs include the following: Multiple departments will require access to the database, including...

Your organization's database needs include the following: Multiple departments will require access to the database, including eCommerce, manufacturing, sales, and customer service Employees will use the database to: Enter data Reference data Use data to auto-populate new orders and customer service records Analyze data and create reports Recommend three of the following six database architecture types that would work for your organization: Hierarchical Network Relational Distributed Relational Object-Oriented Cloud Include the following in your recommendation: Your top three recommended architectures,...

Consider the following set of requirements for a UNIVERSITY database that is used to keep track...

Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students' transcripts. (a) The university keeps track of each student's name, student number, social security number, current address and phone, permanent address and phone, birthdate, sex, class (freshman, sophomore, ..., graduate), major department, minor department (if any), and degree program (B.A., B.S., ..., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address, and to...

14.19. Suppose that we have the following requirements for a university database that is used to...

14.19. Suppose that we have the following requirements for a university database that is used to keep track of students’ transcripts: a. The university keeps track of each student’s name (Sname), student number (Snum), Social Security number (Ssn), current address (Sc_addr) and phone (Sc_phone), permanent address (Sp_addr) and phone (Sp_phone), birth date (Bdate), sex (Sex), class (Class) (‘freshman’, ‘sophomore’, … , ‘graduate’), major department (Major_code), minor department (Minor_code) (if any), and degree program (Prog) (‘b.a.’, ‘b.s.’, … , ‘ph.d.’). Both...

Discuss different ways to identify functional requirements in a Functional Needs Assessment Process. Which is the...

Discuss different ways to identify functional requirements in a Functional Needs Assessment Process. Which is the most compelling, and why?

Question