Sunday, March 22, 2020
Thursday, February 27, 2020
televisions series erd
There are
televisions series, which have names, networks and production companies, and
are identified by the name and network. • A television series has one or more
seasons, which are identified by the number of the season. A season also has
the number of episodes and the year the season starts. No season can exist
without a corresponding series. • A season has one or more episodes, identified
by episode number, which is unique within the season. Each episode also has a
title and a length. No episode can exist without a corresponding season. • An
actor is identified by name and birth date, and also has a nationality. • A
director is also identified by name and birth date, and has a talent agency
that represents him or her. • An actor can appear as a “regular” on a
television series or a guest star on an episode. • An episode has one director.
A director can direct one or more episodes.
Tuesday, February 11, 2020
Follow This Google drive link to download following books for IELTS Writing:
1. IELTS Writing Task 2 Samples by RACHEL MITCHELL2. IELTS Academic Writing Task 1 by RACHEL MITCHELL
https://drive.google.com/drive/folders/1eKOzn2djTpbv04k3mncF01ytmseU8ACb?usp=sharingWednesday, February 6, 2019
Scenario to ERD
A Bus Company owns a number of busses. Each
bus is allocated to a particular route, although some routes may have several
busses. Each route passes through a number of towns. One or more drivers are
allocated to each stage of a route, which corresponds to a journey through some
or all of the towns on a route. Some of the towns have a garage where busses
are kept and each of the busses are identified by the registration number and
can carry different numbers of passengers, since the vehicles vary in size and
can be single or double-decked. Each route is identified by a route number and
information is available on the average number of passengers carried per day
for each route. Drivers have an employee number, name, address, and sometimes a
telephone number.
Scenario to ERD
Suppose you are
given the following requirements for a simple database for the National
Hockey League
(NHL):
- · the NHL has many teams,
- · each team has a name, a city, a coach, a captain, and a set of players,
- · each player belongs to only one team,
- · each player has a name, a position (such as left wing or goalie), a skill level, and a set
- of injury records,
- · a team captain is also a player,
- · a game is played between two teams (referred to as host_team and guest_team) and has a date (such as May 11th, 1999) and a score (such as 4 to 2).
Construct a
clean and concise ER diagram for the NHL database using the Chen notation
as in your
textbook. List your assumptions and clearly indicate the cardinality mappings
as
well as any role indicators in your ER diagram.
Scenario to ERD
A
bus company wants to keep track of its bus routes and schedules. Design an ER
diagram for the database according to the following description. Identify all
constraints and keys: Each
bus route has a route number, a departure station and a destination station. For
each bus route, there is a schedule, which records the departure times of
buses. For
each departure time of each route, a driver and a bus can be assigned (however
this is not necessary - information about the driver or the bus may sometimes
be missing). A
driver has an employee Id, a name and a phone number. A
bus is identified by its license number. The database also records the seating
capacity of each bus.
Scenario to ERD
UPS prides itself on having up-to-date information on the processing and current location of each shipped item. To do this, UPS relies on a company-wide information system. Shipped items are the heart of the UPS product tracking information system. Shipped items can be characterized by item number (unique), weight, dimensions, insurance amount, destination, and final delivery date. Shipped items are received into the UPS system at a single retail center. Retail centers are characterized by their type, uniqueID, and address. Shipped items make their way to their destination via one or more standard UPS transportation events (i.e., flights, truck deliveries). These transportation events are characterized by a unique scheduleNumber, a type (e.g, flight, truck), and a eliveryRoute.
Please create an Entity Relationship diagram that captures this information about the UPS
system. Be certain to indicate identifiers and cardinality constraints.
Saturday, September 23, 2017
Scenario to Entity Relational Diagram
Bangladesh is bestowed by spectacular Natural Beauties. We
can see the glimpse of natural beauties through our numerous tourist spot.
Tourist spots which are at country side rather than close to city are
aesthetically more beautiful. Simple inhabitants, beautiful landscapes, serenity
are some of remarkable features of these places. We can differentiate tourist
spots by their names. Visiting country side spots are less costly than city side’s
spots. You can visit these spots by your own arrangements or by different
travel agencies. Agencies are uniquely identified by their agency id. Each travel
agencies normally operates on a particular region. These regions normally
comprises of several tourist spots within short radius. That’s why travel with
these agencies are very helpful. Bangladesh Parjatan Corporation (BPC) is
trying to improve the ambience of these spots and also takes steps to
promulgate these spots not only towards local tourists but also foreign tourists.
Tourists travel different tourist’s spots and they are identified by their
passport number.
Tuesday, February 28, 2017
Dhaka Traveling Guide APK - Android Application
Click Here to download Apk : Download
If any one want source code comment your email address below.
If any one want source code comment your email address below.
Friday, February 24, 2017
IELTS Speaking - BBC Bangla Fluent Speaking
Here is the google drive link to access file:
https://drive.google.com/drive/folders/0Bx4l59jKNTRHd2pYYnJ1ZmNsSEk?usp=sharing
Assembly Program to Check Input is Digit , Capital letter or Others.
org 100h
.data
msg1 db 'capital$'
msg2 db 'digital$'
msg3 db 'others$'
.code
main proc
;input
mov ah, 01h
int 21h
mov bl, al ; move A to bl register
cmp bl, 30h ; compare bl with ascii value of 01
jge print ; if greater or equal jump to label print
print: ; label print
cmp bl, 39h ; compare bl with ascii value of 09
jle print1 ; if less or equal jump to label print1
jg end ; if greater or equal jump to label print
; new line
mov ah, 02h ; character output function
mov dl, 0Ah ; line feed
int 21h ; dos interrupt
mov dl ,0Dh ; Carriage return
int 21h ; dos interrupt
print1:
mov ax, @data
mov ds, ax
mov ah, 09h
lea dx, msg2
int 21h
ret
end:
cmp bl, 41h
jge print2
print2:
cmp bl, 5Ah
jle print3
jge end1
print3:
mov ax, @data
mov ds, ax
mov ah, 09h
lea dx, msg1
int 21h
ret
end1:
mov ax, @data
mov ds, ax
mov ah, 09h
lea dx, msg3
int 21h
ret
main endp
endp
.data
msg1 db 'capital$'
msg2 db 'digital$'
msg3 db 'others$'
.code
main proc
;input
mov ah, 01h
int 21h
mov bl, al ; move A to bl register
cmp bl, 30h ; compare bl with ascii value of 01
jge print ; if greater or equal jump to label print
print: ; label print
cmp bl, 39h ; compare bl with ascii value of 09
jle print1 ; if less or equal jump to label print1
jg end ; if greater or equal jump to label print
; new line
mov ah, 02h ; character output function
mov dl, 0Ah ; line feed
int 21h ; dos interrupt
mov dl ,0Dh ; Carriage return
int 21h ; dos interrupt
print1:
mov ax, @data
mov ds, ax
mov ah, 09h
lea dx, msg2
int 21h
ret
end:
cmp bl, 41h
jge print2
print2:
cmp bl, 5Ah
jle print3
jge end1
print3:
mov ax, @data
mov ds, ax
mov ah, 09h
lea dx, msg1
int 21h
ret
end1:
mov ax, @data
mov ds, ax
mov ah, 09h
lea dx, msg3
int 21h
ret
main endp
endp
Saturday, February 18, 2017
Assembly Program for Addition two numbers. Number Between 0-9.
- Assembly Code for Addition of 1 digit number(0-9).
org 100h
; Addition of 1 digit
.code
; input 1
mov ah, 01h ; first character input function
int 21h
mov bl, al ; move the content of al (1st number) to bl register
; new line
mov ah, 02h ; character ouput function
mov dl, 0Ah ; line feed
int 21h
mov dl, 0Dh ; carriage return
int 21h
; Input 2
mov ah, 01h ; second character input function
int 21h
mov cl, al ; move the content of al (2nd number) to cl register
add bl, cl ; addition of two numbers
; Newline
mov ah, 02h ; character ouput function
mov dl, 0Ah ; line feed
int 21h
mov dl, 0Dh ; carriage return
int 21h
; Output
sub bl, 30h ; convert to real number entered
mov dl, bl ; move the content of bl (2nd number) to dl register
int 21h
endp
ret
Assembly Code to Solve the Equation 3A+B-2C.
1. Assembly Code to Solve the Equation 3A+B-2C.
org 100h
.code
main proc
; input 1
mov ah, 01h ; Input A
int 21h
mov bl, al ; move A to bl register
add bl, al ; 2A
add bl, al ; 3A
; input 2
mov ah, 01h ; Input B
int 21h
mov cl, al ; move B to cl register
add bl, cl ; 3A+B
; input 3
mov ah, 01h ; Input C
int 21h
mov cl, al ; move C to cl register
add cl, al ; 2C
sub bl, cl ; 3A+B-2C
; new line
mov ah, 02h
mov dl, 0Ah ; line feed
int 21h
mov dl ,0Dh ; Carriage return
int 21h
; Output
sub bl, 30h ;convert to real number entered
mov dl ,bl
int 21h
main endp
endp
.code
main proc
; input 1
mov ah, 01h ; Input A
int 21h
mov bl, al ; move A to bl register
add bl, al ; 2A
add bl, al ; 3A
; input 2
mov ah, 01h ; Input B
int 21h
mov cl, al ; move B to cl register
add bl, cl ; 3A+B
; input 3
mov ah, 01h ; Input C
int 21h
mov cl, al ; move C to cl register
add cl, al ; 2C
sub bl, cl ; 3A+B-2C
; new line
mov ah, 02h
mov dl, 0Ah ; line feed
int 21h
mov dl ,0Dh ; Carriage return
int 21h
; Output
sub bl, 30h ;convert to real number entered
mov dl ,bl
int 21h
main endp
endp
Subscribe to:
Posts (Atom)
How to Write Summary of a Research Paper
Paper Summary should contain the following points: What problem author’s solved? What are the motivations for that problem? Why is it import...
-
At first download the Heart Disease Dataset from Kaggle: https://www.kaggle.com/ronitf/heart-disease-uci . Following, you should put the...
-
Suppose you are given the following requirements for a simple database for the National Hockey League (NHL): · the NHL has many tea...
-
A bus company wants to keep track of its bus routes and schedules. Design an ER diagram for the database according to the following descr...