Question

In: Computer Science

Database Question Create two entities for Online Journalists business. Each entity must have 5 attributes and...

Database Question

Create two entities for Online Journalists business.

Each entity must have 5 attributes and explain the type of each attribute.

Solutions

Expert Solution

Database entities :

The two entities of online Journalists business are
1.Journalist
2.NewsItem

The "Journalist" contains the following attributes as follows

Attribute1:
journalistID :integer
Explanation: The journalistID is the unique key of integer type to identity the journalist in the entity table, Journalist.

Attribute2:
name: string
Explanation: The name of a journalist of string type in the entity table, Journalist.

Attribute3:
age : integer
Explanation: The age of journalist of integer type to identity the journalist in the entity table, Journalist.

Attribute4:
country : string
Explanation: The country of the journalist in the entity table, Journalist.

Attribute5:
salary : double
Explanation: The salary of journalist in the entity table, Journalist.


The 5 attributes of "NewsItem" entity are as follows
Attribute1:
mediaType : string
Explanation: The mediaType is the name of the type of media like text,image,audio or video type of news type.

Attribute2:
date : Date
Explanation: The date of the news item posted

Attribute3:
size : integer
Explanation: The size is the length or size of the news item in bytes or mega bytes or giga bytes.

Attribute4:
viewscount: integer
Explanation: The viewscount is the number of views the news item on published.

Attribute5:
likes : integer
Explanation: The likes is the number of likes the news item got on published.

Entity-diagram:


venereology answered 2 weeks ago
Next > < Previous

Related Solutions

Create a database design with the following rules. List down all the entities and attributes and...
Create a database design with the following rules. List down all the entities and attributes and draw out the relationships. List all the business rules. 1. A person can have multiple accounts (Track individual accounts, Trusts, IRA, 401k, HSA, etc) a. Not all accounts must be through brokerage 2. Multiple brokerages (Fidelity, Vanguard, ect) a. Multiple accounts with different brokerages b. Multiple types of accounts allowed at each broker 3. Categorization of investments (Large Cap, mid cap, small cap, Bonds...
SNOWMOBILE CLUB - Database Development Draw an Entity-Relationship Diagram which must include all entities and their...
SNOWMOBILE CLUB - Database Development Draw an Entity-Relationship Diagram which must include all entities and their attributes. Primary Keys underlined, Foreign Keys labeled, Weak entities double boxed. You have been asked to develop a database to help the Wisconsin Snowmobile Association track their club members. The following are the predefined business rules: 1) Snowmobile Clubs are tracked by Wisconsin county. 2) A club can be assigned to multiple counties. 3) Members can belong to one or more clubs. 4) Some...
Create first draft for online shopping database (SQL): Things to do: Identify the entities Identify the...
Create first draft for online shopping database (SQL): Things to do: Identify the entities Identify the attributes Constraints Relations First Normal form Second Normal Form Third Normal Form Test Query to: Add a new item as a seller Query for total number of sold item in past month Query for total income in US DOLLARS
Question 3: 1. A business entity must be carrying on a trade or business however, the...
Question 3: 1. A business entity must be carrying on a trade or business however, the Internal Revenue Code does not define what is a “trade or business”. a. When there is no definition of trade or business, what authority should you use to determine the definition of a trade or business? b. Download and bring to class the highest source of authority that you could locate on the definition of a “trade or business”.
Create a database and design an ER diagram for the given question. Must link the related...
Create a database and design an ER diagram for the given question. Must link the related tables then implement the design using MySQL. Insert at least 5 records. Ensure that the data to be added are related to other tables. Follow this format in creating the database and table: Database format: databasename_yourname Table format: tablename_yourname QUESTION: Company ABC has the following business rules. A department employs many employees, but each employee is employed by only one department. A division operates...
Create tables according to the mapping. Add 2 records to each. Create 5 queries for database...
Create tables according to the mapping. Add 2 records to each. Create 5 queries for database of 3 table joins to use most of the tables or group of tables in database. You should not have tables that are of no use. Student(ssn, name, major) Class(classID, name, f_ssn) Faculty(ssn, name, office_num, dept_id) Department(Dept_id, office_num, f_ssn) Enroll(s_ssn, classID, grade) Professor(f_ssn, alma-mater, tenured) Instructor(f_ssn, term_degree, type) Lecture(classID, method) Lab(classID, location) Person(ssn, dob, gender)
Create a ‘Student’ table using SQL query. The table must have at least five attributes from...
Create a ‘Student’ table using SQL query. The table must have at least five attributes from your choice with different data types.
You must label each answer with the number of question. Each question must have at least...
You must label each answer with the number of question. Each question must have at least three sentence answers. There is no maximum sentence, use as many as you wish to thoroughly answer the question. All answers must be complete sentences using proper grammar and spelling. Sarah paid $50,000 for a franchise that covers the entire United States. She intended to sell individual franchises for the each state. Naturally, investors considering buying a franchise from her asked to see the...
You must label each answer with the number of question. Each question must have at least...
You must label each answer with the number of question. Each question must have at least three sentence answers. There is no maximum sentence, use as many as you wish to thoroughly answer the question. All answers must be complete sentences using proper grammar and spelling. Assume you are opening a furniture store. You have some decisions about how to do the accounting for the business. Which type of inventory system will you use? Explain your reasons. specific, LIFO, FIFO,...
JavaScript each item must have at least three categorical attributes and at least one numeric attribute....
JavaScript each item must have at least three categorical attributes and at least one numeric attribute. Write a function that counts the number of values each item attribute has. This is effectively a group-by on the item table for each column. For example: if the first attribute is colour, and its values are [ ‘red’, ‘black’, ‘white’, ‘black’, ‘red’ ], the counts for colour would be: red 2 black 2 white 1
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT